RE: Formatting a column - Frank's response

[Frank Radice]

Make sure you include the ' after the last %.  Blank spaces in the format change the display '(%%%) %%%-%%%%' will display as (206)1234-56 [NOTE: There IS a blank space between the ) and the following %].  The absolute position of the - is the critical character for a correct display. -----Original Message----- From: Manuel de Aguiar [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 7:07 PM To: [EMAIL PROTECTED] Subject: Re: Formatting a column (FORMAT(columname,'(%%%) %%%-%%%%)) Good Luck, Manuel Terry Niefield wrote: Hi..Can a a text column of phone numbers (8002225555) be formatted to look like [800] 222-5555 in a computed column?ThanksTerry