Thousands separator rejected

I can copy and paste (e.g. $23,500.00) from the following sources, and simply paste the value into a Numbers v3.6.1 cell with cell format set to automatic. The original formatting is retained.

1. A table cell from Pages v5.6.1

   Formatted to Currency, 2 decimals, and thousands separator

2. A table cell from LibreOffice v5.1.2.2 Calc

   Formatted to Currency, 2 decimals, and thousands separator

3. Document text from Pages v5.6.1

   $23,500.00

4. Document text from LibreOffice v5.1.2.2 Writer
   1. $23,500.00<tab>43,250.33<tab>50,000.00
   2. Values past in three adjacent cells, but only the first value retains its currency symbol. Other values retain thousands separator, and decimals, but cell format for each value is Automatic, not Currency.

Hi Andy,

If the online table is well-formed then you should be able to select the portion you want, command-c to copy, click once in the cell of an existing Numbers table, and command-v to paste. Command-v usually retains the appearance of the online table. Edit > Paste and Match Style will usually succeed in pasting the values while keeping any formats you have already set in the Numbers table.

You might want to double-check that your settings at System Preferences > Language & Region are using the same thousands separator as is displayed in the online table you are trying to import.

SG