Currency Prefix within a cell

Amye

Hi guys and Girls,

 

A quick one I hope. Can I add a 'prefix' to a cell that shows currency? We use SS with AUD and NZD, thing is they are both a $ symbol. Is there any way to make them look more like their own and show $AUD5000 and similarly $NZD5000?

 

We have 2 seperate sheets so if there is a workaround that I can apply to an entire sheet that would be great, and if that workaround still lets me link a cell in teh AUD sheet but SHOW NZD in the column that is great too. 

 

Thanks!

J. Craig Williams

Amye,

 

You may need to have a value column and a display column.

 

="$AUD" + [ValueColumn]23

 

Do all your calcs, sums, counts, on the value column but use the display column for Reports and Sights. Unless you edit from your Reports.

 

Craig