Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training - Custom format
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel training - Custom format
Resolved · Low Priority · Version Standard
Reply
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
For upcoming training course dates see: Pricing & availability
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.
|
 |
|
» Forum post: Option groups |
I have set up an Options Group in my form. and assigne i.e 1- proposed; 2 - confirmed. when creating a report however it comes up with 1 and 2 how do I get it to show proposed and confirmed? As viewers of the report don't know what the numbers are?
