Cell properties

  • Thread starter Thread starter Sync
  • Start date Start date
S

Sync

I have this strange occurrence in Excel 2003:

Every time I put a number in a cell, for some reason it is divided by 100.
So I put 100 in, is converted to 1; I put 35 in, is converted to 0,35
Only when I put 3500 in, it is converted to 35

I have called Windows support, but they can not help me with this problem.
I even have tried re-installing Office 2003 Basic but the problem remains!

Perhaps someone can help me out with this?
I myself think of replacing an .xlt template, but strangely enough there is
no xlt on my PC at all, even not in the Office map !???

Josh
 
Josh

Tools>Options...>Edit>Uncheck fixed decimal places

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top