Help - number formats changing

M

MSL

I don't know if this is a known problem or something peculiar but I am using
Excel 2002 with win 2000 at work and at home.

I brought home file from work and opened it and all the whole numbers in one
column are divided by 100 ie 230 became 2.3 - so, of course, all the
subsequent calculations are adrift.

I'v tried clearing all the formats and reformating the column but same
thing keeps happening.

Any ideas any-one ?

Regards

Scott
 
B

Bob Phillips

Scott,

Go in tog Tools>Options and on the Edit tab, check to see if the Fixed
Decimal places checkbox is set. If it is, unset it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top