excel training - Custom format

Resolved · Low Priority · Version Standard

Fri 1 Dec 2006, 16:45 Delegate Clare said...

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

Mon 4 Dec 2006, 09:42 Trainer Richard said...

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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Change Excel's default font

You can change the default font and font size for all spreadsheets created in Excel by:

1. Going to Tools on the menu bar.
2. Select Options, then General.
3. Next to Standard Font you can change the font and font size.
4. Click OK.

Each new file you start from this point onward should use the font and font size you have selected.

View all Excel hints and tips