Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training - Custom format

excel training - Custom format

ResolvedVersion 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:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines

Excel 2010 allows you to change the colour of grid lines instead of keeping them in boring black.

Select the File tab on the Ribbon, click Options, click Advanced, scroll down to ''Display options for this worksheet.'' Next to ''Gridline colour,'' choose your favourite colour, then once you've done this, click OK. Easy!

View all Excel hints and tips

excel training - Custom format

Custom format

RE: Custom format

Excel articles

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines