Change the format of a cell Programmatically

[Bergfe]

I am trying to change the format of a Cell (or a range) to currency. Right
now it's working just fine as this is:

rangeAmount.NumberFormat = "$0.00";



But the Amount it gives me comes up like this:

$123456789.00



What I want to get is a easier way to read the number:

$123,456,789.00

or

123,456,789.00$ I don't care about the dollar sign, i want my number to be
separated by commas, for visualisation facts



Thanks In advance.



Berge.

 

[Kevin B]

Try this formatting mask:

"#,##0.00"

 

[Jim May]

Try maybe "$#,000.00"

 

[Bergfe]

Thx a lot works just great. Thx for the help.