How can I set up EXCEL to show number without 3 last digits?

[Guest]

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.

 

[Tom Ogilvy]

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