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. |
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. |
All times are GMT +1. The time now is 03:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com