C
ClaudiaV
Hello:
I have Excel 2003 and can't figure out the custom number format to change a
number such as 1,234,567 to 1; or 123,567,890 to 124. This is for accounting
spreadsheets where we report "$ in millions" with no decimal places.
I currently have the following two formats, but they each convert the
example numbers above to thousands -- such as: 1,234,567 becomes 1,235; and
123,567,890 becomes 123,568:
format with dollar sign: _($* #,##0,_);_($* (#,##0,);_($* "-"_);_(@_)
format w/o dollar sign: _(* #,##0,_);_(* (#,##0,);_(* "-"_);_(@_)
How would I change the formats to convert to millions?
Thank you
I have Excel 2003 and can't figure out the custom number format to change a
number such as 1,234,567 to 1; or 123,567,890 to 124. This is for accounting
spreadsheets where we report "$ in millions" with no decimal places.
I currently have the following two formats, but they each convert the
example numbers above to thousands -- such as: 1,234,567 becomes 1,235; and
123,567,890 becomes 123,568:
format with dollar sign: _($* #,##0,_);_($* (#,##0,);_($* "-"_);_(@_)
format w/o dollar sign: _(* #,##0,_);_(* (#,##0,);_(* "-"_);_(@_)
How would I change the formats to convert to millions?
Thank you