| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering a whole number e.g. 4, results in a decimal entry, 0.04
my excel 2003 suddenly developed the above fault, which try as I may, I
cannot cure. If I enter the number with a decimal point after it, it enters as the correct whole number. The selfsame programme on my Vista laptop has not developed the fault (yet, anyway!) Anyone come across this before? Thanks for your attention, J.Fulcher |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
entering a whole number e.g. 4, results in a decimal entry, 0.04
In Options, Uncheck Automatically insert a decimal point.
Bluebottle wrote: my excel 2003 suddenly developed the above fault, which try as I may, I cannot cure. If I enter the number with a decimal point after it, it enters as the correct whole number. The selfsame programme on my Vista laptop has not developed the fault (yet, anyway!) Anyone come across this before? Thanks for your attention, J.Fulcher |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
entering a whole number e.g. 4, results in a decimal entry, 0.04
Tools|Options|Edit tab|uncheck Fixed Decimal places.
It's a handy tool for the accountancy types who don't want to enter decimal points. It's a pain for the rest of us <vbg. Bluebottle wrote: my excel 2003 suddenly developed the above fault, which try as I may, I cannot cure. If I enter the number with a decimal point after it, it enters as the correct whole number. The selfsame programme on my Vista laptop has not developed the fault (yet, anyway!) Anyone come across this before? Thanks for your attention, J.Fulcher -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unwanted decimal places when entering integers | Excel Discussion (Misc queries) | |||
| Format option for decimal. e.g., entering 531 results in 5.31 | Excel Discussion (Misc queries) | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| position of decimal point when entering a number ... | Excel Discussion (Misc queries) | |||
| Entering numbers with variable decimal places. | Excel Worksheet Functions | |||
Linear Mode
