Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have set options to fixed decimal 2 places. But when I enter numbers, i
have to enter all zeros after decimal point. Entering the period does not work. For example, 100.00 must be entered as 10000. If i enter 100. it inputs 1.00. Excel is not accepting a period as a decimal place. Does anyone know what needs to be set for this problem? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
decimal places within a formula | Excel Discussion (Misc queries) | |||
Changing default decimal places | Excel Discussion (Misc queries) | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
Entering numbers with variable decimal places. | Excel Worksheet Functions | |||
Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be. | New Users to Excel |