Having problem with simple division in excel


G

Guest

I am trying to divide two siple numbers
eg. =4/2 and getting error in excel sheet "the formula you typed contains errors" while + - and * is working fine
 
M

MattShoreson

The only way to replicate your error is to type in
=4\2

To avoid the error type in

=4/
 
D

Debra Dalgleish

Maybe you used the backslash ( \ ) instead of the forward slash ( / )
 
G

Guest

i am doing the same =4/
and also check autocorrect there is nothing
I did uninstall and reinstall excel same proble

----- MattShoreson > wrote: ----

The only way to replicate your error is to type in
=4\

To avoid the error type in

=4/
 
G

Guest

no I am not using \ I am using
----- Debra Dalgleish wrote: ----

Maybe you used the backslash ( \ ) instead of the forward slash ( /

Naveed wrote
 
D

Dave Peterson

try checking a windows setting.

Windows start button|settings|control panel|windows regional settings
Number tab

Look at list separator. What do you show there?

If it's a slash, change it to a comma (USA) or semicolon (rest of world??).
 
G

Guest

yes it is working after changing list separator from / to
Thanks a lo
 

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

Top