Format

[Suresh Kusunuri]

Hi members, When I prepare an excel file with normal number format, when I re-open the file again, those numbers changed to Date format all cells in the excel file. Would you please advise any solution for it? I am using Excel 2016 version. Thanks
Suresh

 

[vladimiratanasiu]

Hi members, When I prepare an excel file with normal number format, when I re-open the file again, those numbers changed to Date format all cells in the excel file. Would you please advise any solution for it? I am using Excel 2016 version. Thanks
Suresh

Stop automatically changing numbers to dates - Microsoft Support

Stop Excel from entering dates automatically by changing numbers to dates. You can format cells as text before you enter numbers. Or if you have just a few numbers to work with, enter a space before the number, or an apostrophe.

support.microsoft.com