#1   Report Post  
James
 
Posts: n/a
Default $ 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.
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

"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.



  #3   Report Post  
James
 
Posts: n/a
Default

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.



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maximum Number of Cell Formats Jim Allen Excel Discussion (Misc queries) 4 April 19th 05 07:07 PM
How do I find out how many different cell formats an existing wor. wheelsii Excel Discussion (Misc queries) 1 March 24th 05 04:58 PM
excel date formats changed bob Excel Worksheet Functions 1 March 1st 05 02:59 PM
Copy with link between sheets - all the formats dissapear?!? Kathrine Excel Discussion (Misc queries) 1 February 4th 05 03:45 PM
Too Many Different Cell Formats Nanette Excel Worksheet Functions 1 November 12th 04 04:55 AM


All times are GMT +1. The time now is 03:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"