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
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