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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]$6790.980[/TD]
[TD]$90.00[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]$7982.764[/TD]
[TD]$82.00[/TD]
[/TR]
[TR]
[TD]$2948.286[/TD]
[TD]$48.00[/TD]
[/TR]
</tbody>[/TABLE]

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!