change decimal point on a result

[tim1]

hello, i am calculating the difference of two cells. example, a3=a1-a2. a3 gives me a result with a decimal point, example, 1.34564. i want to move the decimal on the result right one or two spaces. example, 13.4564. a1 and a2 are imported from another worksheet so i am having trouble with this. any idea's anyone? thanks.

 

[Yogi Anand]

hello, i am calculating the difference of two cells. example, a3=a1-a2. a3 gives me a result with a decimal point, example, 1.34564. i want to move the decimal on the result right one or two spaces. example, 13.4564. a1 and a2 are imported from another worksheet so i am having trouble with this. any idea's anyone? thanks.

Hi tim1:

Following is one way ...

Book1
	A	B	C	D	E
1	2.44564	move decimal point by number of places to the right
2	1.1	1	2	3	-1
3	1.34564	13.4564	134.564	1345.64	0.134564
Sheet2

formula in cell B3 is ... =($A$1-$A$2)*10^B2

this is then dragged to right .

I hope this helps.

 

[tim1]

thank you, that worked!