formula

[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/
------------------------------------------------

 

[Ron Rosenfeld]

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?

Add 100000

Format as 000000


--ron