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