G
going nuts
I need to change the formatting of a cell from a dollar amount to a format
that appears DDDDDDDDCC (D=dollars and C=cents). When I custom format the
cell to 10 digits it makes a whole number like 160 appear in the fields as
1.60 (without the decimal). I need it to appear as 0000016000. How can I
format the cell to add the cents on the end of the dollar amount?
that appears DDDDDDDDCC (D=dollars and C=cents). When I custom format the
cell to 10 digits it makes a whole number like 160 appear in the fields as
1.60 (without the decimal). I need it to appear as 0000016000. How can I
format the cell to add the cents on the end of the dollar amount?