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!