Cell Format

[Lori]

I have a PC running Excel 2002. Everytime I enter a
number into a cell it shows as decimal (ex. I enter 1 it
displays as 0.01). I've uninstalled and reinstalled
Excel, checked the Number tab in Format Cells and the
General format is showing 0.01. If I take away the
decimal places, then it shows all numbers as 0. All cells
in a new workbook are doing this. It's like the value
entered, needs to be multiplied by 100 to show correctly.

The other PCs running Excel 2002 are not doing this.

 

[Steve Andrews]

Lori,

Go to Tools/Options and select the 'Edit' tab. If 'Fixed
Decimal' is checked, uncheck it.

Steve

 

[Paul B]

Lori, give this a try, go to tools ,options, edit and uncheck fixed decimal

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **