ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can this be done... (https://www.excelbanter.com/excel-worksheet-functions/9431-can-done.html)

Dan B

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.



JE McGimpsey

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.


Dan B

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

Thanks,
Dan



"JE McGimpsey" wrote in message
...
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.





All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com