Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with fixed decimal
I am using and learning Excel 2003. I checked fixed decimals and checked two
decimals in the options box of the tools menu. The fix word then appears in the lower right hand corner of the screen. The following is my problem: I was taught that by putting a period after a whole number and hitting enter the number will be added to the cell as a whole number and not with a two decimal entry. Example being...input 1009. into a cell and then press enter. The result in the cell should be 1009 but I keep getting 10.09 . I thought that by putting the period after the whole number indicates that the entry will be the whole number and not a decimal entry. Any help would be greatly appreciated. Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fixed Decimal | Excel Worksheet Functions | |||
Format Numbers Without Fixed Decimal | New Users to Excel | |||
Fixed Decimal Question | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
Fixed decimal place | Setting up and Configuration of Excel |