Forum Discussion
Removing leading zeros is not the default, but still wants to convert
Hi, hope someone can help. Excel seems to work differently on each of my PCs. On my newest laptop the leading zeros are being removed by default, even though in Data Options this is not selected. ...
I don't have such option eighter. Answer was generated by AI, it easily could suggest something from Google Sheets or like.
Which options exist:
but it depend on which channel you are if 365 subscription.
That's how to show values, not how convert or not convert them (from text with leading zeroes to number)