Custom number format displaying thousands

J

John Smith

If anyone has any potential solutions to the custom number format
below I would be very grateful.

If the two number formats below are applied to the numbers displayed
in the 'Actual number' column, the output as shown in the columns
'format #1' and 'format #2' are given by Excel.

The output I want to achieve is shown in the final column.

Has anyone got any suggestions how i might achieve this?

format #1 = [>500]#,##0,_);[<-500](#,##0,);
format #2 = [>500]#,##0,_);[<-500](#,##0,);-


Actual
Number Format #1 Format #2 What I want
-501 (1) (1) (1)
501 1 1 1
-499 -- -
499 - -
0 - -

I am aware I could cycle through the output cells in VBA and apply a
'dynamic style' however this would not be a practical solution since
the spreadsheet is fairly large.

Thanks in advance,
John
 
Top