Here is a suggestion from https://discussions.apple.com/message/26532955#26532955

In order to import comma-separated CSV into Numbers.app properly, you need to set the decimal separator to period in System Preferences. If decimal separator is set to comma, Numbers.app can only import semicolon-separated CSV.

  1. Quit Numbers.app;
  2. Set the decimal separator to period, temporarily, in System Preferences; [/Language & Region/Advanced]
  3. Launch Numbers.app, import the CSV file and save the resultant Numbers file;
  4. Quit Numbers.app;
  5. Reset the decimal separator to the original (presumably, comma) in System Preferences;
Answer from Ruskes on Stack Exchange
🌐
Apple Community
discussions.apple.com › thread › 2199079
Adding comma's to numbers with more than … - Apple Community
What if you type "=1200" into a cell? Same questions as above. ... Thanks for your suggestions. 1200 is right justified when entered. I have tried several entry schemes getting the same no comma separator result. Just enter then select number and click the thousands check box.
🌐
Reddit
reddit.com › r/metric › comma as the decimal separator.
r/Metric on Reddit: Comma as the decimal separator.
August 23, 2023 -

Does anyone know how to get the decimal comma on the Apple Mac NUMERIC keypad? I've looked and talked to customer support and still cannot get it to work. They have suggested changing the language which isn't going to work as other languages use the AZERTY layout. there should be a software option that any input on the numeric keypad to enter the decimal marker inserts your desired dot or comma.

Top answer
1 of 4
5
Maybe ask in an Apple or Mac sub? If it were a PC I would go to control panel then clock and region settings but I'm just not familiar with Macs. Are there regional setting you can change?
2 of 4
2
According to various online forums, there are two solutions. For the first, go to: System Preferences>Language and Region>Advanced and change the symbols for Grouping and Decimal in the Number Separator and Currency fields, then click on OK. This should work on any application you use on your Mac. If this doesn't work, try relaunching the Finder or restarting your Mac. (I have tried this on my iMac but it doesn't work for me. I thought this may be because I use a keyboard macro program, Keyboard Maestro, but the problem is still there when I turn KM off.) The second method is to go to: System Preferences>Keyboard>Text Press the + underneath the table of substitutions and enter a period in the Replace column and a comma in the With column. Ensure that the option for Text Replacement is enabled in whatever application you use. This may vary from one app to another. In Text Edit, for example, go to Edit>Substitutions and check Text Replacement. When you type a period from either the Numeric or Alphabetic sections of the keyboard a little window will open next to the period character. At this point, if you type any alphanumeric character the period will change to a comma. If you want to keep the character as a period, press the right arrow key. (This works for me in Pages, Notes, Contacts, and a word processor called Bean. (And when entering input in Chipmunk Basic!) I can't find this function in BBEdit, Neo Office or Open Office, and I don't have any Microsoft apps (Word etc )to try it on. It doesn't work in Firefox or Chrome.) Good luck and let us know if anything works for you.
🌐
Wikihow
wikihow.com › computers and electronics › operating systems › mac › how to change the number format on a mac (with pictures) - wikihow
How to Change the Number Format on a Mac (with Pictures) - wikiHow
March 10, 2025 - It's in the lower right corner. ... Click on a separator. You can choose from a comma, period, apostrophe, space, or none, to select how the system will format larger numbers like 1,000,000.
🌐
Apple Community
discussions.apple.com › thread › 252522743
Numbers: How to append a comma to each wo… - Apple Community
Enter the formula shown below the table in C1, and fill down to the cell to the right of the end of the list. Select and Copy all cells now displaying a comma at the end of the word.
🌐
MacMost
macmost.com › forum › how-do-i-change-the-decimal-point-in-numbers.html
How Do I Change the Decimal Point In Numbers?
October 21, 2019 - I tried this with the opposite situation, changing commas to periods, and it worked for me. Another solution is to open the CSV file in TextEdit, since it is just a text file. Then do a find and replace in TextEdit. Save it out and then bring in the CSV into Numbers. ... Of course! Quite embarrasing that I didn't think of that. Thank you. Comments are closed for this post. MacMost is brought to you ad-free thanks to its supporters!
Top answer
1 of 2
2

You can use a handy feature called AppleScript's text item delimiters, which allows you to break up (or "parse" in computer jargon) text into segments, and then extract data from those segments. They are the separators of text items in a piece of text. A simple example:

set prevTIDs to AppleScript's text item delimiters
set theString to "Don't-eat-the-yellow-snow"
set AppleScript's text item delimiters to "-" --tell AppleScript to break up strings at each occurrence of a hyphen '-' in a given string
set these_items to every text item of theString
//--> {"Don't", "eat", "the", "yellow", "snow"}

set AppleScript's text item delimiters to prevTIDs
return these_items

It is always considered good practice when working with text item delimiters to restore the original delimiters; once you change the delimiters, they will globally affect the running environment until the process is closed and restarted.

Another use for text item delimiters is replacing words or characters in a given string:

set prevTIDs to AppleScript's text item delimiters
set theString to "Don't eat the yellow snow"
set AppleScript's text item delimiters to "yellow" --the word you want to replace
set temp to every text item of theString
//--> {"Don't eat the", "snow"}

set AppleScript's text item delimiters to "pink" --the replacement word
set theString to temp as string
set AppleScript's text item delimiters to prevTIDs
return theString
//--> "Don't eat the pink snow"

However, note that this replaces every occurrence of the word "yellow". The reason I'm saying this is consider the following string:

If someone added one plus one, what would be the result? 

If you wanted to replace the word "one" with the word "two", you would have to be sure to precede "two" with a space when creating the new delimiter, or your resulting string would be the following:

If sometwo added two plus two, what would be the result?

What you're trying to do is basically replacing empty strings with commas. All you need to do is follow these simple steps to do this:

  1. Create a variable to store the current delimiters in
  2. Create a variable to store your string in
  3. Change the delimiter to an empty string ""
  4. Coerce your string into a list (i.e. set the list to every text item of yourString)
  5. Change the delimiter to a comma ,
  6. Coerce your newly created list back into a string (i.e. set yourString to list as string)
  7. Restore the old delimiters
  8. return your string

The resulting code:

set prevTIDs to AppleScript's text item delimtiers
set myString to "0123456789"
set AppleScript's text item delimiters to ""
set the_list to every text item of myString
set AppleScript's text item delimiters to ","
set myString to the_list as string
set AppleScript's text item delimiters to prevTIDs
return myString

Happy coding! :)

2 of 2
1

Something like this?

set theNumber to "3452678190"
set AppleScript's text item delimiters to ","
set theItems to every character of theNumber as string
set AppleScript's text item delimiters to ""
return theItems
Find elsewhere
🌐
ProWritingAid
prowritingaid.com › how-to-add-commas-to-numbers
How to Add Commas to Numbers for Clarity
October 13, 2022 - A comma is placed every third digit to the left of the decimal point and so is used in numbers with four or more digits. Continue to place a comma after every third digit.
🌐
MacRumors
spy.macrumors.com › forums › software › developers › apple programming
How to add commas to numbers? | MacRumors Forums
May 14, 2010 - Then type NSNumberFormatter in the search bar. 2. It's not Objective-C that does this, it's Cocoa. You want to make sure you understand the difference (Objective-C is the language, Cocoa is the set of objects that Apple gives us). Good luck! ... Converting Numbers to Strings With Thousands Separator Here is an example of code that converts numbers to strings with thousands separators:
🌐
YouTube
youtube.com › watch
Commas to Decimals on a Mac - YouTube
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
Published   December 2, 2021
🌐
Automators Talk
talk.automators.fm › macos
Add a comma after the city in a Numbers column - macOS - Automators Talk
November 11, 2018 - Hello, I’m about to upload my Christmas list to create cards and the company wants me to have a comma after the city in the column that has the cities. Is there a way to automate this task? This is in Numbers on MacOS …
🌐
Reddit
reddit.com › r/macos › separator in number format
r/MacOS on Reddit: Separator in number format
May 20, 2022 -

I had set dot instead of comma as separator in number format. After updating to macOS Ventura, numbers in apps now show commas again. How can I set up a German language with number format separator dot instead of comma?

🌐
The Bricks
thebricks.com › resources › how-to-add-commas-to-numbers-in-excel
How to Add Commas to Numbers in Excel
... Right-click Method: Select your cells, right-click, and choose 'Format Cells...' from the context menu. Keyboard Shortcut: Select your cells and press Ctrl + 1 (or Cmd + 1 on a Mac).
🌐
Apple Support
support.apple.com › guide › numbers › format-dates-currency-and-more-tan23393f3a › mac
Format dates, currency, and more in Numbers on Mac - Apple Support
In Numbers on Mac, change the format of text, numbers, currency, percentages, date and time, and durations in a table.
🌐
MacRumors
forums.macrumors.com › software › mac apps
Problems with Numbers, please help. | MacRumors Forums
December 17, 2018 - Check that Mac OS number formatting is set for a comma as the list separator. Save your comma-delimited content to a text file with extension .csv. Open the file in Numbers and it should display correctly.
🌐
Apple Community
discussions.apple.com › thread › 253069482
How to change dots to commas in Numbers - Apple Community
You would start by copy/pasting your column of "numbers" into it. The formulas in that table will convert them to Numbers that you can Copy/Paste Formula Results. ... Calculator commas My calculator is showing numbers the Indian way rather than the western way.
🌐
The Bricks
thebricks.com › resources › how-to-add-a-comma-in-excel-a-step-by-step-guide
How to Add a Comma in Excel: A Step-by-Step Guide
Press the keyboard shortcut Ctrl + 1 (or Cmd + 1 on a Mac). Right-click on the selected cells and choose "Format Cells..." from the context menu. On the Home Tab, click the small arrow icon (the Dialog Box Launcher) in the bottom-right corner ...
🌐
Proofed
proofed.com › home › punctuation tips: using commas in numbers
Punctuation Tips: Using Commas in Numbers | Proofed's Writing Tips
August 27, 2021 - Commas in large numbers can make them easier to read. In this helpful guide, we explain how and when to use commas in numbers.