number entry

[nieuws]

when i enter a number in a cell in excel 2003 worksheet appear in the cell
as the number divide par 1000

e.g. I enter the number 1 in a cell
when I <ENTER>, in the cell appear 0,001

Who can my help

 

[Bob Phillips]

Goto Tools>Options and on the Edit tab there is a checkbox for Fixed
Decimal. Uncheck that box.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)