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")
|