Simple number formatting

[game001]

Hi,

How do I format number to 2 decimals so that "A$" sign comes on left of the cell box and text on the right (like the $ format coming in the last row)

Right now the fomratting looks pretty odd. Image attached.

Also while we are at it, how do I have "US$" format?

Thanks alot

 

[game001]

Hi,

How do I format number to 2 decimals so that "A$" sign comes on left of the cell box and text on the right (like the $ format coming in the last row)

Right now the fomratting looks pretty odd. Image attached.

Also while we are at it, how do I have "US$" format?

Thanks alot

Image not displaying, link below

https://imgur.com/Zad5L7U
https://imgur.com/Zad5L7Uhttps://imgur.com/Zad5L7Uhttps://imgur.com/Zad5L7Uhttps://imgur.com/Zad5L7U

 

[Rick Rothstein]

Give this Custom Formatting type pattern a try...

_(\A$* #,##0.00_);_(\A$* (#,##0.00);_(\A$* "-"??_);_(@_)