Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I set up EXCEL to show number without 3 last digits?
We have a order No in every sell - 83HI256312001 or 83HI256312002.
How is it possible to set up EXCEL to show the number without 3 last digits? Many thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I set up EXCEL to show number without 3 last digits?
You would put in a dummy column and hide this column. If your numbers are
in column A, insert a new B column and hide A. In B2 put in the formula =Left(A2,len(A2)-3) and drag fill down the column. Or you could write a macro to actually remove the last 3 digits sub Remove3() Dim rng as Range, cell as Range set rng = Range(Cells(2,1),Cells(2,1).End(xldown)) for each cell in rng cell.Value = left(cell.Value,len(cell.value)-3) Next end sub -- Regards, Tom Ogilvy "Helena" wrote in message ... We have a order No in every sell - 83HI256312001 or 83HI256312002. How is it possible to set up EXCEL to show the number without 3 last digits? Many thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA write macro change column with 3 number digits to 4 digits the | Excel Discussion (Misc queries) | |||
I cannot enter a number containing more than 15 digits in Excel | Excel Discussion (Misc queries) | |||
Can I have Excel Show the last 8 digits of a Number? | New Users to Excel | |||
How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
how do i show only the last four digits of a credit card number | Excel Discussion (Misc queries) |