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.

Try this formatting mask:

"#,##0.00"
--
Kevin Backmann


"Bergfe" wrote:

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.

Try maybe "$#,000.00"

"Bergfe" wrote in message
...
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.

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

"Bergfe" wrote in message
...
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.