L
Lewis Clark
Hello, Group
I have Excel 2003 set for 2 fixed decimal places. So an entry of "125" goes
into the cell as "1.25"
For whole numbers, the help screen says I can enter "125." (note the decimal
point) and that typing the decimal will override the 2 fixed places and get
"125.00" into the cell. But this does not work - Excel treats "125." the
same as "125" and "1.25" gets entered into the cell.
BUT - when I enter "125.0", the desired value of "125.00" gets in the cell.
Is this a known bug? Is there an easy way to manually override the fixed
decimal place setting by typing in the decimal point? In other words, can I
make Excel do what the documentation says it does?
Thanks in advance for any assistance.
I have Excel 2003 set for 2 fixed decimal places. So an entry of "125" goes
into the cell as "1.25"
For whole numbers, the help screen says I can enter "125." (note the decimal
point) and that typing the decimal will override the 2 fixed places and get
"125.00" into the cell. But this does not work - Excel treats "125." the
same as "125" and "1.25" gets entered into the cell.
BUT - when I enter "125.0", the desired value of "125.00" gets in the cell.
Is this a known bug? Is there an easy way to manually override the fixed
decimal place setting by typing in the decimal point? In other words, can I
make Excel do what the documentation says it does?
Thanks in advance for any assistance.