|
|
#1
09-24-2013, 07:55 AM
|
|||
|
|||
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? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Conditional Formatting for a change in number
|
Alaska1 | Excel | 11 | 07-30-2013 04:01 AM |
|
Number and date formatting
|
dmarie123 | Word VBA | 5 | 02-28-2013 03:10 PM |
|
Phone number formatting
|
Mark Micallef | Outlook | 1 | 08-04-2010 02:38 PM |
| Number formatting in Word table | 8braitp | Word Tables | 0 | 08-27-2009 04:12 AM |
| Different page number formatting. | gerrie | Word | 0 | 04-15-2006 07:31 PM |
Windows XP 
Office 2007
Threaded Mode