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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 23, 2017

Hi Samp,

 

Does dot is your the decimal separator?

 

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