View Single Post
 
Old 09-24-2013, 07:55 AM
funkyfido funkyfido is offline Windows XP Office 2007
Novice
 
Join Date: Jun 2013
Posts: 24
funkyfido is on a distinguished road
Default Number formatting

Hi
I am currently doing a vlookup and on the value returned I want the format to change. I want the cell to be formatted in thousands and also have the thousand separator if the actual figure is in millions.
e.g. 1234567 should be 1,235
-1234567 should be (1,235) in red

The code I am currently using is
Selection.NumberFormat = "0," (this returns 1235 or -1235)


Any ideas how to get it all?
Reply With Quote