in excel formula the comma (,) is no longer accepted but the semi.

G

Guest

when entering formula in Excel the comma (,) is no longer accepted but the
semicolon (;) now has to be used.
Example:
Previous : =if(a2="Yes",a3+a4,b3+b4)
Now : =if(a2="Yes";a3+a4;b3+b4)

How do I change it back to using commas. I don't know how this has happened,
I just arrived at work one day and the changes has occured.
 
T

Tushar Mehta

Not a 100% sure how well XL honors them, but check your Windows
'Regional Settings.'

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel "IF" formula... if this possible ??? 0
Display only unique values in CONCATENATE formula 4
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
Formula to return a formula 1
Formula question from beginner 3
Sorting and COUNTIF 6
COUNTIF, Sorting, on Two Sheets 1
Extend Formula 1

Top