| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic rounding and placement of decimals.
All of a sudden, or so it seems, Excel has decided that any whole number I
type in needs two decimal places. 328 becomes 3.28 When I go into formatting to change the number of decimal places, it then decides to round up and 328 becomes 3. The only way I can get it to actually put 328 in the cell is to type '328. Then I get an error message that asks if I want to convert the text to a number. What is going on and what can I do to fix it? Help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic rounding and placement of decimals.
'Tools' 'Options...' 'Edit' Tab UN-select Fixed Decimal Point. 'OK'
Micky "KHess" wrote: All of a sudden, or so it seems, Excel has decided that any whole number I type in needs two decimal places. 328 becomes 3.28 When I go into formatting to change the number of decimal places, it then decides to round up and 328 becomes 3. The only way I can get it to actually put 328 in the cell is to type '328. Then I get an error message that asks if I want to convert the text to a number. What is going on and what can I do to fix it? Help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding decimals up or down | Excel Discussion (Misc queries) | |||
| Decimals rounding up | Excel Discussion (Misc queries) | |||
| Rounding Up Decimals | Excel Worksheet Functions | |||
| Rounding Decimals | Excel Discussion (Misc queries) | |||
| Rounding Decimals | Excel Worksheet Functions | |||
Hybrid Mode
