I believe i followed your directions correctly.
However when i enter a number I get the ERROR:
"The value you entered is not valid,
A user has restricted values that can be entered into this cell?
i just put the number 12 in and got this message.
Any more information to solve this?
I have an estimating program i am working on and i enter quantity numbers from .123 to 9999.
Any other ideas?
It won't let me NOT enter a number in the length feild
Are you getting it to work on your excel?
OK... so what are the instructions to create this format?
OK... I think i got it. Originally i wanted the same number of characters in the fields.
But... i can live with this.
How are you at macros?
Gary, glad you got it! I've never attempted Macros. Excel isn't my strong suite, and I use it when I have to, but not much more. Is it something specific? I may be able to knock it out for you.
Macros are based around a record-and-run setup. Simply press record, do the macro, then stop recording, and payback
Yes... i was satisfied with your response.
I have several Excel Macro or VBA solutions that i need answers too.
Are you good a Macros and VBA solutions? Or do you know someone who is?
And how do i get you paid?