View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default General Format altered/corrupted?

Hi

Try ToolsOptionsEditremove check mark against Fixed places decimal

--
Regards
Roger Govier

"lwt1973" wrote in message
...
I currently have a user who is using Excel 2003. Since yesterday her
Excel
has had an issue where every cell in every worksheet she opens will become
a
2 digit decimal. You can try to format the cell to general and it will
still
become a 2 digit decimal. We have tried creating a new spreadsheet and
the
default cell will be general but it will change every number to a 2 digit
decimal.

Other users can open up the file and the general format is fine but hers
is
causing the cells to become 2 digit decimal.

I've repaired Excel, reinstalled Excel, and it still is having issues.

Thanks in advance.