![]() |
General Format altered/corrupted?
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. |
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. |
All times are GMT +1. The time now is 10:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com