"Keith Thomas" wrote:

> Try converting the value to DOUBLE first
>
> Format(CDbl(Fields!Phone1.Value, "SQLREPORTS"),"(###) ###-###")
>
>
> "Scott Burke" <ScottBurke@discussions.microsoft.com> wrote in message
> news:6A0CFEB6-5760-43A7-91DD-C9A5B2628B58@microsoft.com...
> > Hi Mischa, Thanks for your time.
> >
> > I have allready tried the format tab. same results.
> > that is why I posted.
> >
> > Scott Burke
> >
> > "mischa" wrote:
> >
> >> Hi Scott,
> >>
> >> I'm but a novice myself, but my best bet would be to right-click on the
> >> field in the layout and go to -> format. There you should select the
> >> '...'
> >> under format, where you can enter your own formatting rules. There you
> >> should
> >> try what you did.... (###)###-###
> >>
> >> Maybe my navigation to the option is a bit off, but I'm sitting on my
> >> couch
> >> at home... not actually using the program.
> >>
> >> Good luck - hope it works!
> >> mischa
> >>
> >> "Scott Burke" wrote:
> >>
> >> > I am trying to format the phone number field in a report.
> >> > The phone number is saved like this: 2126492824
> >> > I wont it to display on the report like this: (212) 649-2824
> >> >
> >> > I tried the format tab, It did no good.
> >> > I trided this :
> >> > =Format(First(Fields!Phone1.Value, "SQLREPORTS"),"(###) ###-###")
> >> >
> >> > I don't get an error but I get this : (###) ###-####
> >> >
> >> > WHY!!!! can't I format this phone number?
> >> >
> >> > Scott Burke