Auto Translation Currencies and displaying the translation currency In Excel

"Using XF Functions how can I display the Currency label i.e. AUD?"

You can't.

You could:

1) Use regular 'ole Excel functionality and put the "AUD" into a cell and then link to it; effectively creating a mock dimension header that indicates what currency is being used in the retrieve.

2) Build real cube view reports which can display a header that contains your C#Cons selection

I'd suggest #2.  In my opinion, XFGetCells are a crutch that should replaced as soon as possible.

-db