Won't divide

  • Thread starter Thread starter Kent F.
  • Start date Start date
K

Kent F.

Excel 2002 will not divide. All other functions are OK. If
formula is as simple as A1/A2, the result is #VALUE! I've
tried all the fixes I can find in local help file. Any
assistance is greatly apreciated.
 
Dave Peterson posted the following in response to a similar question
yesterday:

'==============================
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??).
'================================
 
Thanks Debra....forever in your debt
-----Original Message-----
Dave Peterson posted the following in response to a similar question
yesterday:

'==============================
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??).
'================================



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.
Click to expand...
 
Back
Top