Formula seperators

brianfosterblack

Active Member
Joined
Nov 1, 2011
Messages
251
I have just upgraded to office 365 for Business
All my formulae now contain the semi-colon symbol instead of the comma symbol and I have to capture a formula now using the semi-colon. Is this a setting I need to change to continue using the comma?

e.g. vlookup(A15, A7:C14, 3, false) now shows as vlookup(A15; A7:C14; 3; false)
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Thank you but that is not working
My list seperator is set as a comma but in the formula it is seperated by a semi-colon and not a comma
 
Upvote 0
Have you checked the Language setting in File > Advanced > Language
 
Upvote 0
My language was set to English South Africa and I have now changed it to English US but I still have the same problem. My formula looks like this =COUNTIF(F3:BC3;">=1") where the semi colon is replacing the comma. I now also have to write a formula using the semi colon instead of a comma.
I have another computer running on Windows 7 and office 365 and when I move the same workbook onto that computer the formula shows with a comma
=COUNTIF(F3:BC3,">=1")
 
Upvote 0
It will be something to do with the language settings on the computer, or in Xl.
Unfortunately difficult to help any further without access to the computer.
 
Upvote 0
I have been playing around with this and in my regional settings, advanced settings my list seperator is set to a comma. If I change this to a fullstop, my formula shows as a a fullstop in place of a semi-colon but if I then change my list seperator back to a comma, it once again shows as a semi-colon instead of a comma.
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,998
Members
448,541
Latest member
iparraguirre89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top