2273 becomes 22.73 etc. How do i fix it?

R

Reg Dasanjh

Whenever i enter a number into a cell, it gets decimalised, i.e 2273 becomes
22.73 or 1 becomes 00.1. If i enter 2273.00 then the cell shows 2273 or if i
enter 1.00 it will show 1. I have tried to format the cells but to no avail.
Help!!
 
B

Bob Phillips

Menu Tools>Options and go to the Edit tab.

See if the Fixed Decimal box is checked, if so uncheck it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
C

CLR

Tools > Options > EditTab > uncheck the Fixed decimal box

Vaya con Dios,
Chuck, CABGx3
 
Top