I have several rather lengthy spreadsheets that have a column of text data. Some cells might have just one number in it such as 4. Then some cells might have something like 1-10. I am trying to import these into Access and sort them based on the first number if there is an array such as the 1-10. I know how to get the leading zeros on the single numbers such as 4 but how would I do that on the 1-10? I would like for my current 1-10 to show up at 001-010 while at the same time 11-15 would show up as 011-015. Or I could settle with only adding the leading zeros on the first part so that it ends up as 001-10 and 011-15.
If possible I would like to be able to (using the same formula) also change a single digit number such as 4 to 004.
All of these cells are formatted as text because a number format will not accept the dash.
Does anyone have any suggestions on how this could be accomplished? Thanks.
If possible I would like to be able to (using the same formula) also change a single digit number such as 4 to 004.
All of these cells are formatted as text because a number format will not accept the dash.
Does anyone have any suggestions on how this could be accomplished? Thanks.
