Forum Discussion
Microsoft 365 Excel Convert Numbers Loaded as Text with Leading Zeros
I have a file that imported that has numbers on it with leading zeros. The number was imported as text. How do I get B000123456 when I have 000123456 that came over?
If you are on insider or Current channel you may uncheck default settings in File->Options
Above is for Windows. Not sure about other planforms and channels.