number formating

I have this number 1556.2310 and I want to format it to this $1,556.2310.
Any suggestions? Thanks!Use Format Code C.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jessica C" <jesscobbe@.hotmail.com> wrote in message
news:%23F4jZsuXEHA.1036@.TK2MSFTNGP10.phx.gbl...
> I have this number 1556.2310 and I want to format it to this $1,556.2310.
> Any suggestions? Thanks!
>|||Actually that doesn't work because I want to keep four decimal places and
that rounds it down to two.... what I found is I could set the custom
format to "$#,##0.0000"
Thanks for your help
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:eh6qRzuXEHA.3044@.TK2MSFTNGP09.phx.gbl...
> Use Format Code C.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Jessica C" <jesscobbe@.hotmail.com> wrote in message
> news:%23F4jZsuXEHA.1036@.TK2MSFTNGP10.phx.gbl...
> > I have this number 1556.2310 and I want to format it to this
$1,556.2310.
> > Any suggestions? Thanks!
> >
> >
>|||Yes, that works.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jessica C" <jesscobbe@.hotmail.com> wrote in message
news:%23x8cU4uXEHA.2448@.TK2MSFTNGP09.phx.gbl...
> Actually that doesn't work because I want to keep four decimal places and
> that rounds it down to two.... what I found is I could set the custom
> format to "$#,##0.0000"
> Thanks for your help
>
> "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
> news:eh6qRzuXEHA.3044@.TK2MSFTNGP09.phx.gbl...
> > Use Format Code C.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "Jessica C" <jesscobbe@.hotmail.com> wrote in message
> > news:%23F4jZsuXEHA.1036@.TK2MSFTNGP10.phx.gbl...
> > > I have this number 1556.2310 and I want to format it to this
> $1,556.2310.
> > > Any suggestions? Thanks!
> > >
> > >
> >
> >
>|||Format code C allows the use of a decimal place precision specified: C[0-99]
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:urepF6uXEHA.2408@.tk2msftngp13.phx.gbl...
> Yes, that works.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Jessica C" <jesscobbe@.hotmail.com> wrote in message
> news:%23x8cU4uXEHA.2448@.TK2MSFTNGP09.phx.gbl...
> > Actually that doesn't work because I want to keep four decimal places
and
> > that rounds it down to two.... what I found is I could set the custom
> > format to "$#,##0.0000"
> >
> > Thanks for your help
> >
> >
> > "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in
message
> > news:eh6qRzuXEHA.3044@.TK2MSFTNGP09.phx.gbl...
> > > Use Format Code C.
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > "Jessica C" <jesscobbe@.hotmail.com> wrote in message
> > > news:%23F4jZsuXEHA.1036@.TK2MSFTNGP10.phx.gbl...
> > > > I have this number 1556.2310 and I want to format it to this
> > $1,556.2310.
> > > > Any suggestions? Thanks!
> > > >
> > > >
> > >
> > >
> >
> >
>