E
ellenricca
I have a column of numbers in Excel 2003 that are of General type. I
need to insert a decimal point two positions in from the right of the
existing number. When I do that however by using Format > Cells and
changing it to Number with 2 decimal places, or to Currency format, it
adds a .00 to the existing number instead of inserting a decimal point
into the existing number, e.g., 999955 come out as 999955.00 or
$999,955.00 when what I really want it to do is 9999.55 or even
$9,999.55.
Please help!
need to insert a decimal point two positions in from the right of the
existing number. When I do that however by using Format > Cells and
changing it to Number with 2 decimal places, or to Currency format, it
adds a .00 to the existing number instead of inserting a decimal point
into the existing number, e.g., 999955 come out as 999955.00 or
$999,955.00 when what I really want it to do is 9999.55 or even
$9,999.55.
Please help!