Unable to enter any formula excel 2010 and 2013

[rczomb]

I am getting the error box referring to text vs. formula error when entering any formula, I have checked for viruses and reloaded office 2010 and 2013 and also tried all tne repairs I can think of to no avail
Any help for this old Marine would be appreciated..

 

[Chrisdontm]

Are you saying that you are not able to type in even the simplest of formulas and they won't work...?

When you click FILE, OPTIONS, FORMULAS... That will get you to the page for your formula settings if that will help...

 

[rczomb]

Thanks for the reply.
Yes, any function or formula that requires a comma separator (sp) (all) I get the error box telling me to use a tilde if I want text.
The system is Win 7 Excel 2013, and has been checked for just about everything. Its driving me to drink !!
Well almost.
Bob

 

[Aladin Akyurek]

Thanks for the reply.
Yes, any function or formula that requires a comma separator (sp) (all) I get the error box telling me to use a tilde if I want text.
The system is Win 7 Excel 2013, and has been checked for just about everything. Its driving me to drink !!
Well almost.
Bob

Are you able to enter in a cell:

3

bob

=3

=3+5

=SUMIFS(A:A,B:B,">0")

=SUMIFS(A:A;B:B;">0")

 

[rczomb]

3 yes

bob yes

=3 yes

=3+5 yes

=SUMIFS(A:A,B:B,">0") no

=SUMIFS(A:A;B:B;">0") no

Strange !!!!

Bob

 

[SpillerBD]

result for entering?
= SUM ( B5 ; B6 )

 

[Aladin Akyurek]

3 yes

bob yes

=3 yes

=3+5 yes

=SUMIFS(A:A,B:B,">0") no

=SUMIFS(A:A;B:B;">0") no

Strange !!!!

Bob

Are you on an American system?

What happens when you download and open:

https://dl.dropboxusercontent.com/u/65698317/rczomb system check.xlsx

 

[rczomb]

Are you on an American system?

What happens when you download and open:

https://dl.dropboxusercontent.com/u/65698317/rczomb system check.xlsx

Nothing happens just blank screen and yes i am on a American system, all the setting were also checked against a working program on another computer.
Bob

 

[SpillerBD]

The "list" separator is a system setting found under "Region and Language" in the control panel.
Must goto the "Additional Settings..." to verify the list separator. The Format may indicate "English (United Sates)" but the additional settings can still be changed...

 

[Aladin Akyurek]

Nothing happens just blank screen and yes i am on a American system, all the setting were also checked against a working program on another computer.
Bob

Are you unable to download the file and open it in Excel?