Custom formating of cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dale - 28 Feb 2007 20:36 GMT

I have a number in a cell that is in whole numbers that I needs to be
reported in $,000. In the Format cells menu on the nubers tab there are
several (###.00) type cells. I am importing a lot of data that is in million
of dollar and I want to convert to be reported in thousands. Is there a
formula/conversion I can use in the custom section on the tab to accomplish
this task?

Thanks

Dale

Reply to this Message

Bernard Liengme - 28 Feb 2007 20:57 GMT

Try custom format like
$ 0,
$ #.00,
etc
Note the trailing comma

In Google the search fro <excel format thousands> yielded over 1 million
hits. The first of these was:
http://j-walk.com/ss/excel/usertips/tip017.htm
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>I have a number in a cell that is in whole numbers that I needs to be
> reported in $,000. In the Format cells menu on the nubers tab there are
[quoted text clipped - 8 lines]
>
> Dale

Reply to this Message

Gord Dibben - 28 Feb 2007 21:17 GMT

Dale

Custom $#,#00, will show 23,000,000 as $23,000

Note: the value is still 23,000,000

Gord Dibben MS Excel MVP

>I have a number in a cell that is in whole numbers that I needs to be
>reported in $,000. In the Format cells menu on the nubers tab there are
[quoted text clipped - 6 lines]
>
>Dale

Reply to this Message