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

  • Thread starter Thread starter Martin
  • Start date Start date
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.
 
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:
 
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
 
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
 
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.
 
Back
Top