Can this be done...

Hi,

I'm creating a phone number list. Is there a way in Excel to automatically
put in the .............. after a name? For Example:

Col A Col B
John Doe....................................... (000) 000-0000
Joe Schmo..................................... (000) 000-0000

I just don't want to have to type all those .....................

Thanks.

One way:

Format/Cells/Number/Custom @*.

In article <[email protected]>,
"Dan B" <[email protected]> wrote:

> Hi,
>
> I'm creating a phone number list. Is there a way in Excel to automatically
> put in the .............. after a name? For Example:
>
> Col A Col B
> John Doe....................................... (000) 000-0000
> Joe Schmo..................................... (000) 000-0000
>
> I just don't want to have to type all those .....................
>
> Thanks.

Hi,

A custom number format would do it.

General;General;General;@*.

Cheers
Andy

Dan B wrote:
> Hi,
>
> I'm creating a phone number list. Is there a way in Excel to automatically
> put in the .............. after a name? For Example:
>
> Col A Col B
> John Doe....................................... (000) 000-0000
> Joe Schmo..................................... (000) 000-0000
>
> I just don't want to have to type all those .....................
>
> Thanks.
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

PERFECT!! I knew there had to be someway to do that.

Thanks,
Dan



"JE McGimpsey" <[email protected]> wrote in message
news:[email protected]...
> One way:
>
> Format/Cells/Number/Custom @*.
>
> In article <[email protected]>,
> "Dan B" <[email protected]> wrote:
>
>> Hi,
>>
>> I'm creating a phone number list. Is there a way in Excel to
>> automatically
>> put in the .............. after a name? For Example:
>>
>> Col A Col B
>> John Doe....................................... (000) 000-0000
>> Joe Schmo..................................... (000) 000-0000
>>
>> I just don't want to have to type all those .....................
>>
>> Thanks.