Bryan
This worked fine until we got to MWI499z - for some reason the next number
turned to mwi4100Z. Any ideas?
Thanks
Janet


"Bryan Hessey" wrote:


Assuming 2 header rows, in A3 put

="MWI"&TEXT(ROW()-2,"000")&"Z"

and fomula-drag that as far down as you need.

Adjust the Row()-2 if you don't start on Row 3


Janet T Wrote:
Folks I'm designing a spreadsheet to hold log-on numbers for temporary
workers. The format of the numbers is MWI***Z, where *** is a 3-digit
number. Is there any way I can use an increment function to
automatically
complete a long list of numbers eg MWI001Z, MWI002Z, without having to
type
them all in. I've tried using the fill handle, but it doesn't work on
this -
presumably because its a mix of letters and numbers.
Thanks for any help.
Janet


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=483091