MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Format to $000's

Posted by Dwight on November 08, 2001 8:12 AM

Want to change a long column of numbers which vary from $5,000,000 to $1B+ and format them to show in $000's, ie $5,600,555 would show as $5,600. Did it once but can't remember the formatting trick.


Posted by Barrie Davidson on November 08, 2001 8:16 AM

Custom format to


BarrieBarrie Davidson

Posted by IML on November 08, 2001 8:34 AM

This will show 5000
$#, will show $5000
Any idea how to get it to show as $5,000?

I tried playing but couldn't get it.


Posted by Aladin Akyurek on November 08, 2001 8:50 AM

$#,### maybe? (NT)

Posted by IML on November 08, 2001 8:54 AM

$#,### maybe? (NT)

That helped. I got $5,000,000 with it, but that led to
which looks like it worked. Thanks Aladin.

Posted by Mark W. on November 08, 2001 1:54 PM

Why wouldn't you want $5,601 using $#,##0, (nt)