Calculation always gives zero

[Gianna]

Hello all please help

All of my calculations are equalling 0. I might as well get a calculator out!
If i put one value, say 10 into one cell and then another value, say 3 into another cel, then multiply the two, the answer is zero.

I don't think it is the format of the cells, does anyone know if it could be the settings?

kind regards Zero

 

[PA HS Teacher]

How are you multiplying them together? The following works fine for me.

Book3
	A	B	C	D
1	10	3	30
2
3
Sheet1

In C1:
=A1*B1