ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   General Format altered/corrupted? (https://www.excelbanter.com/excel-discussion-misc-queries/198723-general-format-altered-corrupted.html)

lwt1973

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.

Roger Govier[_3_]

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