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:

A
B
$6790.980
$90.00
$7982.764
$82.00
$2948.286
$48.00



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.