| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
digit in a cell
Each time I enter a numeric, like "1" or "2". The cell defaults to "0.001"
and "0.002" and so on. Until I type "100" returns "1". Please advise me how to restore to true number exactly what I type? Thanks. -- GY Fong |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
digit in a cell
Tools==Options==Edit and deselect "Fixed Decimal places"
HTH "GYFong" wrote: Each time I enter a numeric, like "1" or "2". The cell defaults to "0.001" and "0.002" and so on. Until I type "100" returns "1". Please advise me how to restore to true number exactly what I type? Thanks. -- GY Fong |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
digit in a cell
Thank a lot!
-- GY Fong "Toppers" wrote: Tools==Options==Edit and deselect "Fixed Decimal places" HTH "GYFong" wrote: Each time I enter a numeric, like "1" or "2". The cell defaults to "0.001" and "0.002" and so on. Until I type "100" returns "1". Please advise me how to restore to true number exactly what I type? Thanks. -- GY Fong |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need excel to look for the 4th digit in a cell then insert new num | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| How to replace the last digit in a cell with a letter | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
Hybrid Mode
