Assuming that Column A contains your data, enter the following formula
in B1, and copy down:

=LEFT(A1,LEN(A1)-1)

Then, if you'd like to convert these formulas into values, try the
following...

1) Select Column B

2) Edit Copy Edit Paste Special Values Ok

Hope this helps!

In article ,
Jennings
wrote:

I have a sheet with 10K part numbers that are 10 digits long

Example

5300000030
5301620220
5301621300
5301621610

Is there a way of removing the last digit to make them all 9 digits
long without editing each cell?

example

530000003
530162022
530162130
530162161