Try this:
=Left(A1,5)
And copy down as needed.
OR
=--Left(A1,5)
To make the values true numbers.
OR
Select the column of numbers, then, from the Menu Bar,
<Data> <Text To Columns>
Click on "Fixed Width", then <Next>
Move the "Break Lines" to where you need them,
Then <Finish>.
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
I have 9 numeric characters in a cell and I need to get rid of the last 4.
How can I do that. There are too many cells to manually delete.
