Cell Format

  • Thread starter Thread starter Lori
  • Start date Start date
L

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.
 
Lori,

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

Steve
 
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 **
 
Back
Top