Hello, I need to copy numbers like "-3,129.76" and paste them to my Numbers with european format for currencies, like "-3.129,76"
How can I convert them after paste ? Now I'm writing them manually but I'm sure I can do this better and faster with Numbers !
Thanks for support and "ciao" from Italy :)
Andrea
iMac 27″ 5K, macOS 11.2
Hi Andrea,
With the current (and recent) versions of macOS and Numbers you are able to set the language and region of an individual Numbers document without affecting the settings of the system.
BEFORE starting the copy (from a different source) and Paste (into a Numbers document) change the language and region setting of the Numbers document to English - United States (or to another region that uses the full stop (period . ) as thr decimal separator.
AFTER completing the copy/paste steps switch the document's setting back to the european language set in System Preferences, and, if necessary, set the data format of the cells where the values have been pasted to currency with the appropriate currency symbol.
Regards,
Barry
Hi Andrea,
With the current (and recent) versions of macOS and Numbers you are able to set the language and region of an individual Numbers document without affecting the settings of the system.
BEFORE starting the copy (from a different source) and Paste (into a Numbers document) change the language and region setting of the Numbers document to English - United States (or to another region that uses the full stop (period . ) as thr decimal separator.
AFTER completing the copy/paste steps switch the document's setting back to the european language set in System Preferences, and, if necessary, set the data format of the cells where the values have been pasted to currency with the appropriate currency symbol.
Regards,
Barry
Hi Andrea,
In English format:
Menu > File > Advanced > Language and Region:
Format changed to European, and the formula from SUM to SOMMA 😊
Regards from Australia,
Ian.
Number conversion from usa format to european
