excel dividing all numbers by 10,000

  • Thread starter Thread starter Nhat
  • Start date Start date
N

Nhat

excel 2002 was dividing all numbers by 10000 even though
the data type was general. i tried changing the data
types but to no avail. it pissed me off enough to go and
wipe out the registry settings for excel and the problem
was fixed. what i want to know was what happened? this
happened on my sister's computer. did she activate some
silly formatting? thanks
 
She or someone else did, look under tools>options>edit
and uncheck [fixed decimal places] which I assume was set to 4
 
Back
Top