trying to set a cell to take a phone number starting with +

Good Day

I am trying to compile a list of cell phone numberes.

the numberes start with +263 folowded by 9 digits ( example +263 772 320 090 )

I have some cells where there is no problem but in othere cells it shows the number format 2.63772E+11 all cells have been formatted for General


I am not sure how to fix this.

Help will be greatly appreciated.

Enter an apostrophe before the +

'+263....


BSB

if i put the ' will it not be a problem when I upload it into the phone

replace the + with two zeros
the + is the international exit code, your old national exit code is two zero's which should still work if you have problems with apostrophe.

Thank you

I just dont understand that how in some cells +263 works and otheres it does not

have you got the column formatted as text - if general or number it will not work

Formatting the Cell as Text works perfectly Thank you