Office 2007 Key Custom Number Formats

[weixx827]

I've decided to start posting some of the replies I send to customers who write me asking for help on how to do something in Excel or Excel Services,Office Professional Plus 2010 Key (http://www.office2010key.in/), especially those which I think might be solutions to problems others are likely to have.For my first go I've picked - for no particular reason other than it was one of the more recent mails I've gotten - a question that has to do with custom number formats.This customer writes: What formula could I use to input a number like this 26-859-7423? with the dashes. I would like to be able to just type 268597423 and the number look like 26-859-7423. Can you help me?Yes,Office 2007 Key (http://www.microsoftoffice2007key.net), indeed! Select the range of cells you want to format in this way. Right-click the selection and choose Format Cells. In the Number tab of the Format Cells dialog that appears,Office 2007 Pro (http://www.key-office-2007.de), select the Custom option in the Category list. There's an input box underneath the word "Type:" where you can specify your own custom number format. In your case,Windows 7 Enterprise (http://www.windows7-key.us/), what you want to enter there is 00-000-0000. Click OK.The value "268597423" should now appear as "26-859-7423".For more information on custom number formats,Office 2007 Key (http://www.office2007key.in), see this online help article. <div