your entry cannot be used. an integer or decimal may be required

  • I want to change the maximum change under options > formulas to 0.001, but it keeps showing the error: your entry cannot be used. an integer or decimal may be required


    Even my (point)/delete button on the keyboard will show a (point) in word when I use it, but in excel it shows a (comma)


    I tried the below from an old thread from excel forum, but it didn't work


    Open a new workbook
    hit alt-f11 (to get to the vbe.
    hit ctrl-r (to see the project explorer)
    locate your workbook's project.


    It should look like:
    VBAProject(Book1)


    Right click on that and select Insert|Module.
    Paste this in:


    Option Explicit
    Sub testme()
    With Application
    .Calculation = xlManual
    .Iteration = True
    .MaxChange = 0.001
    End With
    End Sub


    Put your cursor inside that macro (click on With).
    Hit F5 (to run the code).


    Then alt-f11 to get back to excel.
    Can you get to tools|Options|calculation tab
    (And change the calculation back to automatic, too.)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!