Excel Formula Help

[Guest]

I need a formula that will truncate the value and provide the dollar amount
as follows:

Entry Calculated Number
$10.00 = $0.00
$22.50 = $2.50
$50.00 = $0.00
$75.00 = $5.00

I basically need to see the value of the last three digits of the amount
posted in the column. The column contains over 5000 entires, which is why I
need a formula.

Thanks

 

[Peo Sjoblom]

Try

=A1-FLOOR(A1,10)

formatted as currency

 

[T. Valko]

Maybe this:

=MOD(A1,10)

Copy down as needed