RE: Formatting a column - Frank's response

Fri, 20 Apr 2001 14:07:55 -0700

 
-----Original Message-----
From: Frank Radice [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 20, 2001 1:31 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Formatting a column - Frank's response

Make sure you include the ' after the last %.  Blank spaces in the format change the display '(%%%) %%%-%%%%' will display as (206)1234-567  [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

Reply via email to