Pulling 2 digits before a decimal point from adjoining cell then zeros after decimal

Hi, I have been trying to figure out how to pull the last two digits before a decimal point from an adjoining cell so those digits show up in the cell next to it with the digits after the decimal displaying as zeros.

Cells in A column displays $ABCD.EFG
and I want Cells in the B column to display $CD.00

What I mean is:




Any help would be eternally appreciated. THANKS soooo much if you figure this out. I'm relatively new to excel so this is complex stuff for me.

Try:

=MOD(INT(A1),100)

Crossposted elsewhere. Please post your links to your thread in other forums.

Thanks!!!!