«

Quick question -

I have output from a Money MS SQL field going into a repeater's dataitem.
The db does not store any cents (decimals). How can I get this on the page:

<%#DataBinder.Eval(Container.DataItem, "Revenue", "{0:C}")%>

...NOT to display any decimals or cents?

Rather than try to convert the value to Currency, simply prepend it with a $
like the following:

<%#DataBinder.Eval(Container.DataItem, "Revenue", "${0}")%>

If you would like, you can specify that an integer format be used (such as
"${0}"). For more information, see

ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.1033/cpguide/html/cpconstandardnumericformatstrings.htm

Good Luck!
--
Nathan Sokalski

http://www.nathansokalski.com/

"D. Shane Fowlkes" <> wrote in message
news:e4ja$...
> Quick question -
>
> I have output from a Money MS SQL field going into a repeater's dataitem.
> The db does not store any cents (decimals). How can I get this on the
> page:
>
> <%#DataBinder.Eval(Container.DataItem, "Revenue", "{0:C}")%>
>
> ..NOT to display any decimals or cents?
>
>
>
>
>
>
>
>