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

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

 

[muddan madhu]

before "+" add ' (Apostrophe symbol)

 

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

 

[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

 

[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

 

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