formula

  • Thread starter Thread starter matty
  • Start date Start date
M

matty

I have 4000 numbers, however they don't have the area code 01 in fron
of them.
What is the formula for inserting the area code 01 in front of all the
4000 numbers?



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
at http://www.ExcelTip.com/
------------------------------------------------
 
I have 4000 numbers, however they don't have the area code 01 in fron
of them.
What is the formula for inserting the area code 01 in front of all the
4000 numbers?
Click to expand...

Add 100000

Format as 000000


--ron
 
Back
Top