Number format changes to date by itself

P

Pillpshr

I opened a spreadsheet saved earlier in the day. Nearly all of the cells
containing numbers that had been formatted as "number" changed to a custom
date format of Jan-00 or similar. What's up with that? This was in Excel 2007
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove date format? 3
Auto Cell Format Change from General to Custom Date 1
Excel cells changes number format automatically 0
Number formatting lost 0
Unwanted reformatting of protected cells 0
Excel converted numbers to dates suddenly in All Sheets!!!! 3
unintended format changes Excel 2007 3
BUG - Global Format changes Number and Dates 2

Top