I am trying to calculate the USD:AUD conversion from M3 and show the result of the current conversion rate in the next cell, but it is only resolving the date

I am trying to get cell M3 to convert to AUD in cell N3


This formula has worked in the cell above and converted the "live" rate, but when I amend it for other cells it throws up a random date such as 27/01/1900.

I have another part of the spreadsheet which converts the currency on a particular date, this however needs to be current and update itself with the live prices whenever I check it.

anyone able to help?

1 Answer 1


When it throws up a random date, try selecting the cell and choosing FormatNumberNumber.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.