Forum Discussion

José Angeles's avatar
José Angeles
Copper Contributor
Sep 26, 2017

Problem with numbers division

Hi, this should be a very easy one, but I've not been able to solve it.   If I type a numbers division, like say "=3/4", Excel will automatically replace that simple formula with its result, "0.75"...
Formulas & Functions
Need Help
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 26, 2017

Hi Jose,

 

Do you mean you see 0.75 in formula bar instead of =3/4 (and no such effect for =3+4) without pressing F9 for PC version?

 

José Angeles's avatar
José Angeles
Copper Contributor
Sep 26, 2017

Yes, in the formula bar the =3/4 is replaced with the result 0.75, therfore the cell also displays 0.75.

 

I have Office 365 (therefore, the latest version of Excel, i.e. 2016 in this case), PC version (running on Windows 10), and I do not press F9.

 

There is not such effect with additions, substractions or multiplications, only with divisions.

 

Thank you, Sergei.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Sep 27, 2017

    Jose, to clarify - that's only with =3/4 or with any division, let say =10.741/3.14?

    • José Angeles's avatar
      José Angeles
      Copper Contributor
      Sep 28, 2017
      It seems to happen with any division.
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Sep 28, 2017

        Jose,

         

        I was not able to reproduce that if only not to apply the macro like

        Sub Tst()
Dim cell As Range
For Each cell In ActiveSheet.UsedRange.SpecialCells(xlFormulas)
  If InStr(cell.Formula, "/") Then
    cell.Formula = cell.Value
  End If
Next
End Sub

        but you have that on empty workbook... Also din't see such bug was mentioned.

         

        Perhaps it's worth to repair the Office if helps.

         

Resources