Corrupt "IF" Formula

[thesillyscot]

Help

I have a spreadsheet that I have not used in quite a while, infact I now have a different PC. Within the spreadsheet I have formulas with "IF" function formulas. However the comma's which seperate the arguments have changed into small square boxes, and when I try to change the formulas in any way I get message saying I have missing parenthesis. This also happens if I type a new formula with comma's seperating the arguments. Basically the spreadsheet won't recognise comma's in new formulas, and has changed comma's in existing formulae to square boxes !!

Any Ideas ???

[speric07]

What version of Excel are you using now??? What version was it made in???

I have had this happen on spreadsheets made on a different version of Office i.e. 2000 and then opened on 2003 many years later.


Sorry I can't remember how I got around it. I think I just copied the formula and then removed the square and replace with correct information.

Hope this helps.

[thesillyscot]

I am currently using Excel2003 and the spreadsheet with the problem was created in 2002.

However I have just tried typing a formula with an IF function in a new sheet, and I get the message "The formula you typed contains an error" which it doesn't !!

[speric07]

Hi,

Have you got an example of the formula ??

Thanks

[thesillyscot]

I have got the answer from another forum, thanks anyway.

The answer was to go into Control Panel-Regional Settings-Customise and set the "," as the list seperator.