horrible problem with division in Excel

[TextPartner]

Hi,

I've recently purchased Office2003 and there is a horrible problem in
Excel that none of friends can help me solve. I cannot make it divide
two cells. The formula =A1/A2 is not working and returns an #ARG!
Other calculations are fine. It is just dividing that causes the
problem. I also switched off the option for "/" as Excel menu button
but it is no good.

I would greatly appreciate any suggestions for possible solutions.

Many thanks to all.

Marek

 

[JE McGimpsey]

I'm not familiar with the #ARG! error - perhaps it's a Polish
localization.

By any chance do you have R1C1 references set (Tools/Options/General)?
That returns the #NAME! error in my version (MacXL04), since XL won't
recognize the "A1"-style reference.

 

[Dave Peterson]

My guess is that you have your windows list separator set to the / character.

In win98, I can get to it via:

Windows start button|settings|control panel|regional settings applet
Number tab
At the bottom of that dialog is the box to review.

Most in the USA use comma (,). Most in Europe use the semicolon (.

If that's not it, what's in A1 and A2?