RE: [KCFusion] Number format

[George Quade]

Title: Message

Try this.         <td>(#left(distribution.MPhone,3)#) #mid(distribution.MPhone,4,3)#-#right(distribution.MPhone,4)#</td>   MPhone is a field with 1234567890 in it.   George Quade     From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Johnson, Kevin X [Tek systems Contractor for Sprint] Sent: Tuesday, May 04, 2004 10:55 AM To: [EMAIL PROTECTED] Subject: [KCFusion] Number format   Hello all,   How do I format a number from a database. For example if the number is:   1234567890 how would I make it look like (123)456-7890