Generate sequential numbers with define format.
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! |
Generate sequential numbers with define format.
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! |
Generate sequential numbers with define format.
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! |
Generate sequential numbers with define format.
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") |
All times are GMT +1. The time now is 01:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com