ExcelBanter - $ Formats

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - $ Formats (https://www.excelbanter.com/excel-discussion-misc-queries/19953-%24-formats.html)

James

$ Formats

Hello again,

I'm trying to change the format of a cell so that it
reads as "AUD$" rather than just "$".

I have tried the custom formats, but can't get it to work.

Any assistance would be greatly appreciated.

Peo Sjoblom

"AUD"$#,##0.00

--
Regards,

Peo Sjoblom

"James" wrote in message
...
Hello again,

I'm trying to change the format of a cell so that it
reads as "AUD$" rather than just "$".

I have tried the custom formats, but can't get it to work.

Any assistance would be greatly appreciated.

James

Thanks!

-----Original Message-----
"AUD"$#,##0.00

--
Regards,

Peo Sjoblom

"James" wrote in message
...
Hello again,

I'm trying to change the format of a cell so that it
reads as "AUD$" rather than just "$".

I have tried the custom formats, but can't get it to
work.

Any assistance would be greatly appreciated.

.

All times are GMT +1. The time now is 02:33 PM.