Excel replacing comma with I in formulas

Hello,

I'm having a very confusing issue with Excel. Anytime I try to enter a formula that needs a comma to seperate cells (like product or vlookup), the comma is replaced with an I (the letter). As a result I get the error message "the formula you typed contains an error". This happens when I manually enter the formula or when I use the formula wizard. To make is even more odd, the formula will work if I put a $ in front of the cell name. Here is an example of what I am talking about...

=product(A2, B2) - this is what the formula should be, but this does not work

=product(A2I B2) - this is what Excel does when I use the formula wizard, still gives me an error

=product($A2I B2) - this ends up working and multiplying the two cells.

I am using Excel 2007. It is driving me nuts. Any thoughts...?

Thank you.

I would take a look in your autocorrect list and see if it has a comma to replace with the letter. You could test this as the autocorrect is shared between office applications. e.g it should do it in word too

Let us know if this doesn't work and we will investigate more

I tried the autocorrect as well, it makes the change in Word, but in Excel it does not make the change. Formula's will not work with the comma. It seems to only work with an I or : as a seperator and with a $ in front of the first cell name. This is with any formula (sum, product, vlookup, etc.). Very odd...

Albert

Very strange. If there was an entry in Word and you deleted it then it should apply to all Office applications. Did you re-start Excel after?

If that didn't work I would look at your regional settings (In windows control panel)

Next, I would say to take a look at whether you have any strange add-ins at work or maybe a virus? Certainly never heard of it before.

Is it this way on all workbooks, even a new one?