Data in Text Format to Dollars and Cents

[rhull]

I hope I can explain this properly. I have a data file that has text entered as "amount" column (M in the example below). The results I need are column L to break down the cents (which I can simply use a =right(2,0) formula). The question I have, then, is column K. How can I extract the "Dollars" as the text without rounding up or down? In particular, please note the second line of data - we need $360 (and not $361 via round function). Any ideas on a formula I can use for column K?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=LEFT(M2,LEN(M2)-2)

 

[rhull]

Almost! Now it has to add the .00 to the end...

Darn banks.

I've read Bill's information in Strategic Finance for 30 years now. This is one of the best resources out there for sure!

 

[lrobbo314]

Book42.xlsm
	A	B	C
1	Dollars	Cents	Amount
2	$8,760	0	876000
3	$360	95	36095
4	$4,000	0	400000
5	$2,750	0	275000
Sheet6

Cell Formulas
Range	Formula
A2:A5	A2	=INT(LEFT(C2,LEN(C2)-2))
B2:B5	B2	=INT(RIGHT(C2,2))

 

[Fluff]

Almost! Now it has to add the .00 to the end...

Not sure how it would do that as the formula return text, unless column M isn't text.

 

[rhull]

I think what I have will work now - thanks for the help!

 

[Fluff]

Glad we could help & thanks for the feedback.