| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Truncating whole numbers - diplaying thousands instead of full num | Excel Discussion (Misc queries) | |||
| numbers truncating | Excel Discussion (Misc queries) | |||
| Combo Box - Show only first two digits? | Excel Discussion (Misc queries) | |||
| Truncating numbers | Excel Worksheet Functions | |||
| How do I shorten 10-digit # so only 6 digits show up? | Excel Discussion (Misc queries) | |||
Linear Mode
