Number cells are automatically convert to date

Question

I have been working with an excel sheet for quite some time , it has around 30 worksheet and lot of data related some reports .. recently I found that all the number fields are changed to date format..I haven't done changes . Any suggestions .. the same thing repeating with some. Other files too.. kindly for your advise. When tried the same file with other computer after changing the format it works fine .. in my computer after changing it back to original format , it is changing again to date

Answer 1

Hi @Shabeer Acheerakath

Select the cells that are incorrectly showing dates, right click and select "format cells"

You will get a box like in the screenshot below, select the type of data you want to display in your cells, probably numbers by the sound of it. Click OK and they should change from dates back to numbers.

Kind regards,

Jamie Sabbatella

Answer 2

Hi @Shabeer Acheerakath ,
Welcome to Q&A forum!

According to your description, please check and try the following information to check this issue.

• Does this issue only ocurr in a special file? Does this problem only occur in special files? Please create a new workbook to check this issue. If only a special file has this issue, I would suggest that you change the cell format to Text for checking.

• Try to open the file in safe mode: Search "run" on Windows search bar to open Run app, type "excel /safe" and press Enter to open the Excel app in safe mode, and then open the file to check.

Beisdes, here is an official article about how to stop automatically changing numbers to dates, please check if it helps you.

If none of the above works, please try to repair your Office to check again.

Hope the information is helpful to you. Any updates, pelase let me know.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.