Clare has attended:
PowerPoint Intermediate Advanced course
Excel Intermediate course
Custom format
Please could you tell me how to format cells containing international telephone numbers including the international dialing code (ie +33 265....)? Additionally, how do you format it so that it can account for the North America dialing code of +1 only?
Thanks
RE: Custom format
In the custom number format option (Select cells, Right Click, Format Cells, NUMBER tab, Custom), enter the following code.
+## (###) ###-####
That will work for both +33 and +1 codes.