adding number formats or formatting cells

November 22, 2010 at 11:52:46
Specs: Windows XP
I am trying to change $706,200 to $706.2k. How do I do this

See More: adding number formats or formatting cells

Report •

#1
November 22, 2010 at 13:03:39
Format...Cells...Custom:

[>999]$#.0,"k";$#

Change the back end of that format ($#) to be what you want for values not >999.

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •
Related Solutions


Ask Question