Share via

Excel division no longer working!

Anonymous
2020-12-02T14:41:05+00:00

I am wondering if anyone can help me resolve this problem. 

Excel will no longer let me divide anything, instead it shows the the following error: 

"There's a problem with this formula."

All other arithmetics work as expected, the issue only happens with division (/). 

When trying to divide two numbers that already exist in the sheet I get the following error:

My current settings (and no, there was no difference when changing the menu key from / to something else): 

And build:

Can someone please make my excel useful again ?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2020-12-02T15:19:10+00:00

    I suspect that your region/language list-separator choice got changed.  It should be comma or semicolon, but it might be set to forward-slash.

    This is a system configuration change, not Excel.  But close all Excel windows first.

    On my Win7 system, I click Start (lower-left desktop toolbar) > Control Panel > Region and Langugage > Additional Settings, and either click Reset or at least change List Separator.  Then click Apply or OK.

    Win10 navigation might be (very?) different.

    Restart Excel, and verify that =6/2 now works.

    4 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-12-02T15:27:05+00:00

    Thank you so much! That did the trick!

    0 comments