View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KRC
 
Posts: n/a
Default Serial Numbers that begin with Text

I need to assign several thousand numbers. However, the numbers must
begin with the text ISRC US-ABC-06- How can I use this prefix and
then automatically assign numbers.

For example:
ISRC US-ABC-06-00001
ISRC US-ABC-06-00002
ISRC US-ABC-06-00003