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!

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Marcos" wrote:

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!

One way:

\EI-P-0000

In article ,
Marcos wrote:

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!

Marcos wrote:
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!


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