Add +33 to a phone number

Solved
vincentj44 Posted messages 20 Status Membre -  
vincentj44 Posted messages 20 Status Membre -
Hello,

I need to add +33 to my mobile numbers in my Excel 2003 spreadsheet.
I found an explanation by going to "format" "custom" and selecting +33 for France, but I can't find this option in my cell format.

I have a solution, but it takes longer by creating a custom format for each number. So if someone has a faster method.

Thank you

Configuration: Configuration: Windows 7 / Firefox 45.0

3 réponses

vincentj44 Posted messages 20 Status Membre 4
 
I found it, you just need to add an apostrophe before the number:

'+33612345678
4