Hello,
I have what might be a simple question for all you smart Excel users out there.
I have a list of numbers, that goes from 1 - 3065. My issue is, I want to add the text ML before each number.
So from numbers 1-10, I want three zeros before the number, so:
ML0001
ML0002
....and so on.
Numbers 10-99, I want two zeros, before the number, so:
ML0050
ML0051
...and so on...
Then numbers, in the hundreds, I only want 1 zero, then numbers in the thousands, no zeros need to be inserted, just the ML text. Does anyone know of a formula or VBA code that might work?
thanks
Bookmarks