I am attempting to format a cell as currency with AUD as the symbol
I have attempted to use a custom style of "[AUD]#,##0.00;-[AUD]#,##0.00’’ (and various other combinations) but Excel complains with a "file Error, some file formats will be lost"
Any idea how I can format a cell so that currency appears something like -AUD123.99?
Thanks in advance
Could you please post your sample code here? A sample project is more helpful to figure out this problem.
And you can try this attached version.
Have worked out how to do this. The currency must be formatted like [$AUD], i.e. the currency specifier format is [$]