number entry

  • Thread starter Thread starter nieuws
  • Start date Start date
N

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
 
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)
 
Back
Top