excel training - Custom format

The UK's most regular instructor-led training courses.
Training information: excel training · Excel courses london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Custom format

Clare has attended:
Powerpoint Advanced course
Excel Intermediate course

by - delegate Clare [1 post] (2006 Dec 1 Fri, 16:45) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 9 Wed	Bloomsbury	0	FULL
2003/XP	2008 Jul 9 Wed	Bayswater	2	book now	£195	£205
2003/XP	2008 Jul 16 Wed	Tooting	0	FULL
2003/XP	2008 Jul 16 Wed	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Jul 18 Fri	Southwark	4	book now	£224	£235
2003/XP	2008 Jul 23 Wed	Southwark	0	FULL
Full Schedule: See all 143 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Custom format

by - trainer Richard platinum contributer [761 posts] (2006 Dec 4 Mon, 09:42) Reply

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.

· Customized Financial Excel Courses in London
· Microsoft Excel's Best Kept Secret
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Benefits of learning about Excel charts
· Microsoft Excel Courses Teach Advanced Macro Techniques

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips