Truncating numbers to show last three digits
 

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

Truncating numbers to show last three digits
 

If exactly as your sample.

Select the range of numbers.

DataText to ColumnsFixed widthnextyou 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


On Sat, 13 Oct 2007 18:19:01 -0700, 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

Truncating numbers to show last three digits
 

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

Truncating numbers to show last three digits
 

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

"EricK" wrote in message
...
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

Truncating numbers to show last three digits
 

=A1-ROUNDDOWN(A1,-1)

"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