irudyk

Coordinator

ssblue

Test your restores, not your backups...

Bill Prew

<div>
<div class="content wysiwyg-content">
Excel &nbsp;- &nbsp;Need help getting the following formula working. Formatting for a phone number using periods.<br />
<br />
&nbsp; =TEXT(A31,&quot;###. ###.####&quot;)<br />
<br />
A31 &nbsp;= &nbsp;1111111111<br />
<br />
wanting &nbsp;= &nbsp; 111.111.1111
</div>
</div>


Excel  -  Need help getting the following formula working. Formatting for a phone number using periods.

  =TEXT(A31,"###. ###.####")

A31  =  1111111111

wanting  =   111.111.1111

Phone number formatting using periods

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.