One way:

Format/Cells/Number/Custom @*.

In article ,
"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.