Converting text numbers to include a '.' before the right two digits

[jschrock]

Hey guys,

I guess I'm just being dense because this doesn't seem like something too difficult, but I'm hitting brick walls at all of my ideas. So I have text numbers pulled from our database and when they pull the data there is not '.' where there should be for normal dollars and to be able to add up as dollar values. I'm having difficulty coming up with a way to make various lengths convert with a single formula. I guess I could do a nested IF, but I thought I would see what clever thing you guys may have. I always learn new stuff when I post!

Examples=

175 = 1.75
4385 = 43.85
13479 = 134.79

Thanks everyone!

 

[Fluff]

How about
=A1/100

or put 100 into an empty cell, copy it then select the data to be changed & paste special Divide

 

[JoeMo]

Maybe:

Book1
	A	B
1	175	1.75
2	4385	43.85
3	13479	134.79
Sheet5

Cell Formulas
Range	Formula
B1:B3	B1	=N(A1*1)/100

 

[jschrock]

Beautiful guys. I told you that I was overthinking it.....trying to be to fancy and looking like an idiot. I've never used the 'N' function before. Both of these obviously work, but like I said, I always learn something new when I post!

Much appreciated!

JT

 

[Fluff]

Glad we could help & thanks for the feedback.