Thread: Generate new account numbers?

I have a spreadsheet with 900 ish account names. I want to know if there is
a way to have Excel auto generate a unique account number for each one. I
will then input this number in my contact manager database for identifying
unique accounts, VLOOKUP's, etc........

Thanks!

Alan

you could use autofilling

type the 1st acc no - 10123
and the 2nd - 10124

select both cells and replicate down as ness


"Alan" <alan@alan.com> wrote in message
news:#aGKIEeyFHA.2008@TK2MSFTNGP10.phx.gbl...
> I have a spreadsheet with 900 ish account names. I want to know if there
is
> a way to have Excel auto generate a unique account number for each one. I
> will then input this number in my contact manager database for identifying
> unique accounts, VLOOKUP's, etc........
>
> Thanks!
>
> Alan
>
>

Easy enough! Thanks for the help!

"JethroUK©" <reply@the.board> wrote in message
news:1qW0f.1217$1u1.867@newsfe4-win.ntli.net...
> you could use autofilling
>
> type the 1st acc no - 10123
> and the 2nd - 10124
>
> select both cells and replicate down as ness
>
>
> "Alan" <alan@alan.com> wrote in message
> news:#aGKIEeyFHA.2008@TK2MSFTNGP10.phx.gbl...
>> I have a spreadsheet with 900 ish account names. I want to know if there
> is
>> a way to have Excel auto generate a unique account number for each one.
>> I
>> will then input this number in my contact manager database for
>> identifying
>> unique accounts, VLOOKUP's, etc........
>>
>> Thanks!
>>
>> Alan
>>
>>
>
>