multiply calculation

Question

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 normal values like +1+1 it works perfectly

but decimals it does nie

can someone tell me how do I need to enter it

sergeibaklan · Answer

Hi Samp,&nbsp;Does dot is your the decimal separator?&nbsp;

samp k · Answer

how to I correct it sergai&nbsp;

luis fernando · Answer

Go to File Menu ribbon and change in options.

samp k · Answer

when at ribbon - formulasat enable iterative calculationit says maximum = 100maximum change 0,001&nbsp;in the windows 8 version it says 0.001and it seems I cannot get the 0,001 change to 0.001or must I go elsewhere to change itthe rest of the indicators are the same as on my windows 8 version computer&nbsp;

sergeibaklan · Answer

Hi,&nbsp;That's not the Excel settings but your Windows one. For Windows 10Settings-&gt;Region &amp; Language-&gt;Additional date, time &amp;regional settings (at the top right of the window)-&gt;Change date, time or number format (you may jump here directly from control panel if you use it)-&gt;Additional settingsand here check what is your decimal symbolYou 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&nbsp;

Forum Discussion

multiply calculation

5 Replies

Resources