2273 becomes 22.73 etc. How do i fix it?

[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!!

[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)

"Reg Dasanjh" <Reg [email protected]> wrote in message
news:[email protected]...
> 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!!

[CLR]

Tools > Options > EditTab > uncheck the Fixed decimal box

Vaya con Dios,
Chuck, CABGx3



"Reg Dasanjh" wrote:

> 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!!