|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 5th, 2005, 12:23 PM
|
|||
|
|||
in excel formula the comma (,) is no longer accepted but the semi.
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. 
|
|
#2
April 5th, 2005, 12:47 PM
|
|||
|
|||
|
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 In article , says... 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| WHY | General Discussion | 9 | December 16th, 2004 12:49 AM | |
| Formula result shows as zero Excel 2003 | Serena | General Discussion | 2 | November 7th, 2004 11:21 PM |
| Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |
| Excel no longer allows new formulas containing the division "/" operator | SA | Setting up and Configuration | 1 | November 1st, 2003 08:20 AM |
| Excel formula bar | Rohan | Setting up and Configuration | 1 | October 29th, 2003 02:31 AM |
Linear Mode
