Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
General Format to Custom format problem KELC-F/A Excel Discussion (Misc queries) 1 May 2nd 08 09:51 PM
Format: General - Text - General iturnrocks Excel Worksheet Functions 3 August 11th 06 04:47 PM
excel numbers in general format i cant add cant change format claude Excel Worksheet Functions 2 July 7th 06 08:18 PM
Change general format to US date format woodlot4 Excel Discussion (Misc queries) 3 October 11th 05 12:29 AM
Change General Format to Currency Format Freshman Excel Worksheet Functions 3 July 8th 05 03:42 AM


All times are GMT +1. The time now is 06:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"