# change decimal point on a result

#### tim1

##### New Member
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.

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

#### Yogi Anand

##### MrExcel MVP
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
ABCDE
12.44564move decimal point by number of places to the right
21.1123-1
31.3456413.4564134.5641345.640.134564
Sheet2

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

this is then dragged to right .

I hope this helps.

#### tim1

##### New Member
thank you, that worked!

Replies
4
Views
388
Replies
2
Views
201
Replies
3
Views
133
Replies
3
Views
87
Replies
3
Views
839

1,191,116
Messages
5,984,737
Members
439,906
Latest member
Sekiro1899

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back