Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
General Format to Custom format problem | Excel Discussion (Misc queries) | |||
Format: General - Text - General | Excel Worksheet Functions | |||
excel numbers in general format i cant add cant change format | Excel Worksheet Functions | |||
Change general format to US date format | Excel Discussion (Misc queries) | |||
Change General Format to Currency Format | Excel Worksheet Functions |