Forum Discussion

samp k's avatar
samp k
Copper Contributor
Oct 23, 2017

multiply calculation

I have excel 2007 on a windows 10 system when I put +0.3*0.4 or =0.3*0.4 or =+0.3*0.4 it gives me a value error on previous windows 8 system my calculation was +0.3*0.4 and it gave a value if I use...
Formulas & Functions
Need Help
samp k's avatar
samp k
Copper Contributor
Oct 23, 2017

how to I correct it sergai

 

Luis Fernando's avatar
Luis Fernando
Copper Contributor
Oct 23, 2017

Go to File Menu ribbon and change in options.

  • samp k's avatar
    samp k
    Copper Contributor
    Oct 24, 2017

    when at ribbon - formulas

    at enable iterative calculation

    it says maximum = 100

    maximum change 0,001

     

    in the windows 8 version it says 0.001

    and it seems I cannot get the 0,001 change to 0.001

    or must I go elsewhere to change it

    the rest of the indicators are the same as on my windows 8 version computer

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Oct 24, 2017

      Hi,

       

      That's not the Excel settings but your Windows one. For Windows 10

      Settings->Region & Language->Additional date, time &regional settings (at the top right of the window)->Change date, time or number format (you may jump here directly from control panel if you use it)->Additional settings

      and here check what is your decimal symbol

      You may change it here but that will be applied not only to Excel but to entire system.

      Not sure about Excel 2007, but for 2016 you may change the decimal symbol for Excel only in Options

       

Resources