Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
number entry
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
number entry
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing a Number in a Column Using Arrays | Excel Worksheet Functions | |||
Mileage Claim Formula | New Users to Excel | |||
How do I show a surplus number in an entry (on the plus side) | Excel Worksheet Functions | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Preceding a number by zeros, that is still a number | Excel Worksheet Functions |