Whether there is a better way to deal with this I don't know but I have a file sent to me every week that I cannot alter or affect the format it comes in. It has a list of products some which are all numeric but most have a Letter prefix. I need to have all the numbers as text even if they are a number if you see what I mean.
My current solution (not really a solution) is to go into the file and replace say 12948 with '12948 and format to general, there are not too many of these and it's not a disaster but ideally I would love to have a macro do this for me, the numbers are always in the same column "B", from row 2 to unknown (end of file), additionally there are a couple of products that have a leading zero so I would need to replace 5252 with '05252, although these numbers can be specifically mentioned in the code as there are only a handfull of them.
I would guess I need to use "For each Cell in Range"
and some kind of replace function with an isnumeric test but that's as far as I have got, I haven't really got a clue where to start with the syntax.
Any tips/ideas greatly appreciated.
My current solution (not really a solution) is to go into the file and replace say 12948 with '12948 and format to general, there are not too many of these and it's not a disaster but ideally I would love to have a macro do this for me, the numbers are always in the same column "B", from row 2 to unknown (end of file), additionally there are a couple of products that have a leading zero so I would need to replace 5252 with '05252, although these numbers can be specifically mentioned in the code as there are only a handfull of them.
I would guess I need to use "For each Cell in Range"
and some kind of replace function with an isnumeric test but that's as far as I have got, I haven't really got a clue where to start with the syntax.
Any tips/ideas greatly appreciated.