Truncating numbers to show last three digits

[Guest]

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

 

[Gord Dibben]

If exactly as your sample.

Select the range of numbers.

Data>Text to Columns>Fixed width>next>you will see 25, 22 etc.

Drop a line down by clicking between the 2 & 5 and next>"do not import(skip)"

Hit Finish.


Gord Dibben MS Excel MVP

 

[Guest]

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

=a1-10*INT(a1/10)

Eric

 

[David Biddulph]

Or =MOD(A1,10)
--
David Biddulph

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

=a1-10*INT(a1/10)

Eric

 

[Guest]

=A1-ROUNDDOWN(A1,-1)