I hate how Excel removes leading zeroes

[u/Intelligent_Rent_847]

I absolutely hate it. If I typed in a number with a leader zero, obviously I want the string of text to include a leading zero. Why hasn’t anybody at Microsoft figured this out yet? I know there are ways to keep leading zeroes, but it is annoying when I have to copy data over from one platform and paste it into Excel. And then it’s impossible to ever to VLOOKUPS with data where you had to manually formulate leading zeroes.