2000 becomes 20 in XP

MrPeder

New Member
Joined
Nov 24, 2005
Messages
2
I have I problem with my Excel XP. When I type 2000 the cell value is shown as 20.
Of course I have reintsalled Excel but same **** after a while.
Anyone who can help?
Peder Skogaas, Norway
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

XL-Dennis

Well-known Member
Joined
Jul 27, 2002
Messages
1,920
Peder,

See if the following can be of help for You:

1. Open Excel
2. Choose the command Tools | Options
3. Choose the tab Edit
4. Uncheck the Fixed Decimals.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,798
Messages
5,574,372
Members
412,589
Latest member
ArtBOM
Top