Why does the format matter? Can't you change the format as needed?

If you have multiple currencies and need to calculate between them,
you probably should have the name of the currency at the top of the
column (or beginning of row) for visual reference, or Vlookup
reference. That would be easier than trying to make sure the numbers
are formatted with the proper symbol.

Or maybe I am completely misunderstanding you.