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.
Thanks,
Dwight
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
Barrie,
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.
thanks,
Ian
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)
