Thread: 8500 cells with phone number(7 char.), wishing to add area code (10 char.)
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default 8500 cells with phone number(7 char.), wishing to add area code (10 char.)
In case there's a need to pad col A to 7 digits
(eg: "6" digit numbers with dropped leading zeros)

Put instead in B1, and copy down:
="123"&TEXT(A1,"0000000")

Then copy col B and overwrite col A with a:
Paste special Check Values OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply With QuoteReply With Quote