alpha numeric table

N

Nathan

I need to create a alphanumeric sequence that is
5955PARS0014401 that is the start of the sequence
and i want the numbers after then PARS to increase by 1

please help
 
T

Tim Ferguson

I need to create a alphanumeric sequence that is
5955PARS0014401 that is the start of the sequence
and i want the numbers after then PARS to increase by 1
Click to expand...

Use an autonumber and use a Format property of

"5955PARS"0000000


-- but of course if the "5955PARS" bit is ever likely to change then you'll
have to do something different.

HTH


Tim F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate Mail Merge Record Every Time 5
Header Roman Numeral to Regular Numbers 1
How to print two a6 booklets (A5 unfolded) on A4 paper? 3
VBA works in orignal but fails in copy of database 1
Help with an Excel macro please? 6
MS Project. Real progress of the project, % complete 1
Auto Increment by 1 Letter 3
Limit drop down items based on another cell 3

Top