Pulling two digits before a decimal point from adjoining cell

[jadess916]

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

<tbody>
</tbody>

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.

 

[XOR LX]

Hi,

Hard to be sure but perhaps:

=FLOOR(MOD(A1,100),1)

Regards

 

[jadess916]

OMG! THANKS sooooooooooooo much! I tweeked it so that the B column would display blanks as well, thank you so much!!!!

If anyone is interested, the formula I used combined XOR LX's and is: "=IF(ISNUMBER(A4),FLOOR(MOD(A4,100),1),"")"

 

[XOR LX]

You're welcome!