Hi all

I have a coulmn of figures that my user whats to format with comma seperators and decimals, only when they exist

so

1234444
15125.33
124000
1156.36
123556.01

should report as below

1,234,444
15,125.33
124,000
1,156.36
123,556.01

etc.


VBA code gives me the choice of
Selection.NumberFormat = "#,##0.00"
or
Selection.NumberFormat = "GENERAL"
anybody know of a way to combines these at all??

All help appreciated as usual