remove last digit on a series of numbers

[s_d_hw]

Hi all,

I have a spreadsheet, with about 1,500 lines. In column A is a list of numbers that I need to remove the last digit from each number, for example in A22 is 02602726521 - I need this to be 0260272652. The numbers are all uniqe.

How can I remove the last digit from every number, without going in manually to do so?

Thank you!

 

[missqueena]

This post has been super helpful for me as well. In my file however I noticed that the cell has to be formatted as text. I'm successful 10% of the time. Can someone explain why copy pasting this formula in my file does not work all the time? I get a #VALUE! error.

 

[Aladin Akyurek]

This post has been super helpful for me as well. In my file however I noticed that the cell has to be formatted as text. I'm successful 10% of the time. Can someone explain why copy pasting this formula in my file does not work all the time? I get a #VALUE! error.

What is the formula that you use?

 

[JohnWood]

i have a excel. there are more than one formulas..