Goto ToolsOptions 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)

"nieuws" wrote in message
...
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