You could also use a custom number format.

Click Format/Cells, select custom and in the text box enter

"E"000"L"

When you enter number 1, should appear as

E001L

Note that this will affect only how the number is displayed on the screen,
excel will still store the values as numbers (which is important if you plan
to use this data as arguments in other formulas - but you could always use
the TEXT function to do the necessary conversion).



"Push Latency" wrote:


Greetings.

I am compiling an archive of the recorded lectures at a university. I
am trying to have Excel automatically add a specifically formatted
reference number in its own column along with each entry on each row,
(something like "E001L... E002L...E003L, etc.).

I imagine that this is an extremely simple function, but it seems that
it the simplest of things is also often the most elusive. I think this
has something to do with either dynamic ranges or arrays...

Thank you, in advance, for any help anyone can offer!


--
Push Latency
------------------------------------------------------------------------
Push Latency's Profile: http://www.excelforum.com/member.php...o&userid=28364
View this thread: http://www.excelforum.com/showthread...hreadid=479433