# Moving Decimal Places...

#### Mr Jay

##### New Member
Hey everybody,

I've been trying to figure out how to convert, lets say 177.23 cents per pound to 1.7723 dollars per pound....This involves moving the decimal place, but I can't seem to figure it out. I have about 92 values all pasted and transposed into a column. They are all in cents, and I need it converted to dollars. I don't want to move the decimal place manually for each cell...(Hope this doesn't sound idiotic!) Thanks!

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Hello and welcome

you can use this formula in the next column,
if 177.23 is in a1 then in b1 put

=a1/100

easy ?
This message was edited by sen_edp on 2002-09-14 15:49
This message was edited by sen_edp on 2002-09-14 16:09

Great! Well, that was simple enough (duh)... In the next column, I wrote =A1/100 , then just dragged it down, as it converted all the other numbers. I still got some learning to do...Thanks for your help!

also :

put 100 in a spare cell

copy it

highlight your range of big numbers

paste / special / divide

it'll divide the whole range by 100 in one go

delete the cell with 100 in it

(you can mentally remember that there are 4 options for this : divide, multiply, add and subtract..... for another day!)

Great! Wow, another way to do it, I'm learning more every day, thanks!

Chris, your suggetsion of placing 100 in a spare cell and using the special paste function is one I've never heard of. A Great time saver Thank you.

Last edited:
Hello everyone! I have a slightly different query in regard to this. I have the value upto 4 decimal places. How can i separate the LHS part of the decimal to one cell and the the RHS part of the decimal to other cell? Its urgent, kindly help!

For LHS, u can use
=int(A1)
For RHS, u can use
=A1-int(A1)

That worked... Thanks very much.

Replies
14
Views
328
Replies
10
Views
200
Replies
4
Views
170
Replies
1
Views
632
Replies
2
Views
245

1,202,911
Messages
6,052,517
Members
444,588
Latest member
ViJN

### 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