Numerical formatting

[heathbo]

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

[Winon]

Hello heathbo,

The way I see it, is that it is either coffee or tea. I would suggest you use;

Selection.NumberFormat = "#,##0.00"

Regards

[AlKey]

Just tried this and got the desired result:

Highlight data and apply "General" format.

[heathbo]

Hi AlKey

Not sure what you have, but "General" does not add the coma separators

thanks both,, if they still want it, will have to format each separatly which I didn't want

regards