G
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
$25.00 = $5.00
$22.00 = $2.00
$13.50 = $3.50
$10.00 = $0.00
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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
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
G
Guest
This formula will do what you want assuming the input is always like xxxxx.xx
=a1-10*INT(a1/10)
Eric
=a1-10*INT(a1/10)
Eric
D
David Biddulph
Or =MOD(A1,10)
--
David Biddulph
--
David Biddulph
EricK said:This formula will do what you want assuming the input is always like
xxxxx.xx
=a1-10*INT(a1/10)
Eric
G
Guest
=A1-ROUNDDOWN(A1,-1)