What is best way for Apple Numbers to recognise currency that does not conform to Numbers Preferences?
I have to calculate prices in downloaded spreadsheets of numerous regions. Their currencies don’t match Numbers preferences.
Example is USD instead of US$
How to get Numbers recognise USD is US$?
iPad mini 6, iPadOS 17
Sunnyintoronto123 wrote:
What is best way for Apple Numbers to recognise currency that does not conform to Numbers Preferences?
downloaded spreadsheets of numerous regions. Their currencies don’t match Numbers preferences.
How are you downloading "spreadsheets"? CSV?
Can you give an example of what your table looks like? shift-command-4, drag to select area, release, start new post here and use the mountains-and-moon 'Image insertion' icon to attach the screenshot from the Desktop.
Also keep in mind that before importing you can go in your menu to File > Advanced > Language and Region ... and switch temporarily to a region that uses the currency format. Open the download with data, and switch back to your original region.
If none of that works then there are ways to strip the USD from the import. But that requires an understanding of the specifics, hence the request for a screenshot.
SG
Morningstar fund is example of currency prefix. Only if I know how to paste table with formatting in post…
thanks and regards
AB FCP I - Global High Yield Portfolio (AT - AUD Hedged)
Historical Price
Date
NAV
Offer Price
Bid Price10/13/2023AUD 9.78000--10/12/2023AUD 9.77000--10/11/2023AUD 9.80000--10/10/2023AUD 9.78000--10/09/2023AUD 9.72000--10/06/2023AUD 9.71000--10/05/2023AUD 9.70000--
Sunnyintoronto123 wrote:
Only if I know how to paste table with formatting in post…
Screenshot. Instructions in post above.
SG
How to get Apple Numbers recognise USD is US$ (which is listed in Number Currency)?
