Formatting numbers for a bank upload

[Bruinaura]

I have a file that displays dollar amounts as such:

30
86.25
150
170.84

So it's really $30.00, $86.25, $150.00, $170.84

I have to convert those numbers so that they become as follows:

3000
8625
15000
17084

So it's not just a matter of adding a set number of following zeroes, because sometimes the numbers don't require extra zeroes, they just need the decimal removed. For the life of me I cannot find a simple way to do that other than retyping them, but I have close to 200 different figures and that gets to be a pain.

Help?!

 

[DRSteele]

Welcome to the forum.

Just multiply each cell by 100. A la,

Book1
	A	B
1	30	3000
2	86.25	8625
3	150	15000
4	170.84	17084
Sheet32

Cell Formulas
Range	Formula
B1	=A1*100

 

[Bruinaura]

Oh MY stars. I figured it would be something so simple I would be too dumb to figure it out. Thank you so much!

 

[DRSteele]

You're welcome.

You aren't dumb. Remember, beer fixes excel problems.