Convert to currency format in excel formula

[madocar]

Hi,

please is there any way how to convert
number format (1 345)
to
currency format ($1 345)
by using a formula?

I tried this formula

=TEXT(B4,"[$$-C09]# ##0")

but finally it happened to be a text string.

Thanks for any help

 

[PCosta87]

Hi,

Why not just use:
"=B4"

and format the cell to currency

or if you must use formula...
=DOLLAR(B4, 2)

 

[bosco_yip]

Maybe......

Format the cell to Currency >> in the Symbol box, choose "$ English (Australia)" from the dropdown list.

or

Format the cell to Custom >> in the Type box, enter: [$$-C09]# ##0

Regards
Bosco

 

[madocar]

It must be the formula.

I come from EU so formula

=DOLLAR(B4, 2)

gives me EUR sign instead of dollar sign.

 

[Syedali]

Hi,

In the currency cell right click > format cells >Number tab > Currency>Symbol change to euro....

 

[madocar]

Once again please, it must be the formula.

I know how to format the currency by clicking on the cell >format cells ...

Thanks

 

[Syedali]

PFA. This my try just check