decimal separator in Numbers

Hi Wayne -

Thank you for the prompt response. To answer your questions;

I initially tried changing the settings while Numbers was open. Switching location seem to have an immediate effect. As switching location to US is not the desired way to do this, I reverted back to my current location (South Africa) and tried setting the decimal separators, under Advance tab, of both Currency and Number to use a full stop. After this is tried relaunching Numbers and even restarted, but the problem persists.

Switching location to US and customising settings under advanced tab seems to work 100%. It then leads me to believe the problem is isolated to combination of Numbers and Africa/European location settings that will not accept full stop as decimal separator.

Calculator i.e. accepts the change form comma to full stop, the problem seems to be only when using Numbers.

Regards,

Hi -

Please see below. I did three screen grabs:

1. General settings under System Preferences (choosing location)

2. Advance tab - customising decimal separators

3. Table in Numbers indicating difference in using comma and point under current settings.

Please let me know if there is anything else.

Thanks.

Wayne -

Further to my previous msg;

With location set to South Africa and both Number and Currency set to 'full stop' as decimal separator -

1. I started a new Numbers spreadsheet.

2. First set (A1) cell properties to Currency and enter "1"

3 Result is "R1,00" (comma) is diplayed and cell property remains Currency

4. Second cell (A2) properties set to Currency and enter "1.2" (point)

5. Result is "1.2" (point) is displayed and cell property is automatically changed to "Automatic".

Regards,

Friedl

Thanks. will do 🙂

Indeed it has. Solved endless problems I used to have with CSV files 🙂