RE: [KCFusion] Number format

[Johnson, Kevin X [Tek systems Contractor for Sprint]]

Title: Message

Thanks George,   Worked like a charm.   KJ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Quade Sent: Tuesday, May 04, 2004 11:14 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Number format 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