How to force Excel to use commas and not semicolons in formulas

**Kitko** · 11-23-2022, 10:49 AM

Hi,

I couldn't get the simple =CONCAT(A1, A2) to work. =CONCAT(A1:A2) worked perfectly, but the former didn't. All I got is the 'problem with the formula' message.

I tried cell formatting, new sheets, nothing worked. I was barking mad.

And then I replaced commas , with semicolons ; and voila.

The official in-app user guide (Excel for Mac Help) says that =CONCAT(A1," ", A2) is correct. I'm using Excel for Mac 16.67 under 365 subs on a Ventura Mac.

My system is set to US English, I'm using US keyboard layout, my region is Czechia - which uses 1 300 000,25 format. Is this the reason? Is there a way how to force Excel to use commas? I couldn't find anything in the Excel Settings pane and I'm reluctant to change the Mac's system preferences.

The thing is that if I paste content of that uses commas, I end up with text values...

Any advice appreciated.

Thanks.

**Pepe Le Mokko** · 11-23-2022, 10:52 AM

You will have to change the regional settings of your PC to US. ( mine are set to European here)

Capture.PNG

**Kitko** · 11-23-2022, 11:02 AM

Originally Posted by Pepe Le Mokko

You will have to change the regional settings of your PC to US. ( mine are set to European here)

Attachment 806287

Thanks Pepe, changing just the number format did the trick

Attachment 806289

**Pepe Le Mokko** · 11-23-2022, 11:15 AM

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

**Kitko** · 11-24-2022, 04:35 AM

Thanks for the reminder, Pepe

How to force Excel to use commas and not semicolons in formulas

LinkBack

Thread Tools

Rate This Thread

Display

How to force Excel to use commas and not semicolons in formulas

Re: How to force Excel to use commas and not semicolons in formulas

Re: How to force Excel to use commas and not semicolons in formulas

Re: How to force Excel to use commas and not semicolons in formulas

Re: How to force Excel to use commas and not semicolons in formulas

Thread Information

Users Browsing this Thread

Similar Threads

NEW version of Excel destroying Formulas in complex workbook by force-adding AT Operator!?

Export worksheet to CSV, strip extra commas (derived from formulas with blank data)

elliminate commas, semicolons, colons, etc. from a string

[SOLVED] Is there a way to force excel to retain formatting when you paste or use formulas?

Basic find and replace macro for commas and semicolons

help with semicolons and commas

[SOLVED] Importing csv data (with semicolons) into excel

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions