View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bahareh Bahareh is offline
external usenet poster
 
Posts: 19
Default 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