Excel converted numbers to dates suddenly in All Sheets!!!!
Hi Shane
I pushed "Yes" button. Made me laugh to this disaster bug instead of anger.
you deserved it.
I had done it before. But what if I didn't have the back up? Opps!
David, I have no micro on my file. That's why so strange.
Thank Both for your care
BHR
"Shane Devenshire" wrote:
Hi,
Simple solution is to get your backup file.
If this helps, please click the Yes button
cheers,
Shane Devenshire
"Bahareh" wrote in message
...
Hello
I saved a file which includes records in Number Formats. Then I closed it.
Next time when I opened the file All Numbers were changed to Date Format.
{God!!!!!!} Why did this happens? How can I make the changes back?
Some of the Cells must be in Text format and some in Date format and some
in Number format That is why I can't select the whole spreadsheet and make
change format to Numbers. Do I have to change each cell format manually.
My Excel is 2007 but my freinds also with 2003 had similar problem. This
was
the first time I saw this.
Thanks
BHR
|