| 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 | |||
Linear Mode
