Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 2

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automaticalle generate sequential reference number	Rachel	Excel Discussion (Misc queries)	2	November 19th 08 05:16 PM
Sequential Numbers	Scott Hemphill	Excel Worksheet Functions	8	August 6th 07 03:38 PM
Sequential Numbers	abcdexcel	Excel Discussion (Misc queries)	3	January 18th 06 11:06 AM
sequential numbers	Harley	Excel Worksheet Functions	1	January 12th 06 09:57 PM
sequential numbers	AndrewRichardWood	Excel Discussion (Misc queries)	2	July 20th 05 05:00 PM

All times are GMT +1. The time now is 11:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us