how to add a "+" to a number in a cellâ€

M

Martin

I have a long list of phone numbers. I need to add a "+" in the beginning of
the number before I import them in Outlook.
 
M

Martin

but how can I add the plus to the list of numbers? I tried with "Find" and
"Replace", it didn't worked for me?

"muddan madhu" skrev:
 
M

muddan madhu

try this

select the telephone numbers then ctrl + 1 , u will get format cell
window | in number tab choose custom | in type: put this +0

click ok
 
F

Fred Smith

Muddan,

Your suggestion won't help. Changing the format will not change the
underlying data.

Regards,
Fred.

try this

select the telephone numbers then ctrl + 1 , u will get format cell
window | in number tab choose custom | in type: put this +0

click ok
 
F

Fred Smith

In a separate column, use:

="+"&a1

And copy down. Adjust the range to suit your situation.

Then either export this new column, or Copy/Paste Special...Values to
replace the old column with the new.

Regards,
Fred.
 
Top