Column Formatting

G

G4

I am using Exell 2003, when i enter a number it appears as a 2 decimal place
fraction, rather than a full number.
The work sheet was created, originally in Office 97
 
B

Bob Phillips

Are you saying that the number is correct, just rounded to two decimal
places? If so, reformat the cell(s) as General.

If you mean say 100 is showing as .01, this sounds like Fixed Decimal. Go to
menu Tools>Options>Edit and uncheck the Fixed Decimal box.
 
Top