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:
A column:
$6790.980
$7982.764
$2948.286
B column:
$90.00
$82.00
$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.
|