This formula will do what you want assuming the input is always like xxxxx.xx

=a1-10*INT(a1/10)

Eric

"Doug" wrote:

I need to figure out how to have the numbers truncated as follows:

$25.00 = $5.00
$22.00 = $2.00
$13.50 = $3.50
$10.00 = $0.00
--
Doug