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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Dale" wrote in message
...
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