Dear all here!!
The question I have is a little bit more complicated.
A bit of background:
I have a string of numbers and characters and I have a Macro that I copy-pasted from somewhere online that REMOVES any character that is not a number.
Is a great Macro that transforms:
"-a209 03 . 1 - 22 46" to 2090312246
I can send the code on request.
However the problem comes when running the macro into that string excel transforms it DIRECTLY into a Numeric.
That is we are missing the first two, or first characters when they are zeros.
For example: "007 01 1.32.08" becomes 70113208 in stead of: 0070113208
And this is a problem.
I have tried to define the cell as text before running the macro. Fails.
I have tried to re-define the cell afterwards as text but the zeros do not appear. Fails.
My last hope is anyone of you help in:
Including in the Macro a last minute section that forces the cell to remain as text...(seems easy! but I have do not know how to program in VBA)
I have another idea, but this ones seems the easiest and most sensible one.
Thank you very much in advance for everything!!
Have a great night, day etc.. wherever you are!
A.
The question I have is a little bit more complicated.
A bit of background:
I have a string of numbers and characters and I have a Macro that I copy-pasted from somewhere online that REMOVES any character that is not a number.
Is a great Macro that transforms:
"-a209 03 . 1 - 22 46" to 2090312246
I can send the code on request.
However the problem comes when running the macro into that string excel transforms it DIRECTLY into a Numeric.
That is we are missing the first two, or first characters when they are zeros.
For example: "007 01 1.32.08" becomes 70113208 in stead of: 0070113208
And this is a problem.
I have tried to define the cell as text before running the macro. Fails.
I have tried to re-define the cell afterwards as text but the zeros do not appear. Fails.
My last hope is anyone of you help in:
Including in the Macro a last minute section that forces the cell to remain as text...(seems easy! but I have do not know how to program in VBA)
I have another idea, but this ones seems the easiest and most sensible one.
Thank you very much in advance for everything!!
Have a great night, day etc.. wherever you are!
A.