Generate sequential numbers with define format.

M

Marcos

I need to generate sequential numbers with the following format; EI-P-0001.
I have tried the TEXT function but apparently ("E) causes some #value error.
If I use other letters its fine, but the "EI-P-0000" returns an error. Help!
 
S

Shane Devenshire

Hi,

Just drag the fill handle down. If EI-P-0001 is in A1 then drag the fill
handle (bottom right corner square of the cell border for A1) down.
 
G

Glenn

Marcos said:
I need to generate sequential numbers with the following format; EI-P-0001.
I have tried the TEXT function but apparently ("E) causes some #value error.
If I use other letters its fine, but the "EI-P-0000" returns an error. Help!
Click to expand...


="EI-P-"&TEXT(A1,"0000")
 

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

automatic formatting phone numbers in excel 6
sequential number code 5
Concatenate Date and Number field for Append Query 0
Creating independant Arrays of sequential numbers 1
Scrabble Value calculation for Welsh words 0
Access Macro Repeat Expression using value of a field in table 0
Format custom number: C-0000-L 2
how to generate sequential numbers with access 2

Top