repeat begining number

[chuck]

We are having to enter a number of 10 digit phone numbers
an wonder if there is a way in Excel to repeat the first 3
digits that are the same through out the spreadsheet?
Trying to speed up data entry.

 

[NH]

enter the 7 digits number in cell A1 and On cell B1 enter the formula
=201&a1
replace 201 with the correct area code

 

[Frank Kabel]

Hi
use a custom format such as
"012"0000000

 

[Ron Rosenfeld]

We are having to enter a number of 10 digit phone numbers
an wonder if there is a way in Excel to repeat the first 3
digits that are the same through out the spreadsheet?
Trying to speed up data entry.

Format/Cells/Number/Custom Type: "nnn-"000-0000

Replace nnn with your area code

Enter the actual phone number WITHOUT the hyphen.


--ron

 

[Chuck]

Thanks for your help. I knew it was something like that
but could not find it in the book.

Thanks again

 

[Chuck]

Thanks for your help. I knew it was something like that
but could not find it in the book.

Thanks again