Text Format for Decimal

[pvong]

I'm grabbing "Amount" from a DB with Decimal format. The outpul of
AmountL.Text comes up as 9999999.99 and I want to format this so it is
displayed as 9,999,999.99. Can someone help me with this simple task?

AmountL.Text = dr.Item("Amount")

Thanks!

Phil

 

[Alexey Smirnov]

I'm grabbing "Amount" from a DB with Decimal format. The outpul of
AmountL.Text comes up as 9999999.99 and I want to format this so it is
displayed as 9,999,999.99. Can someone help me with this simple task?

AmountL.Text = dr.Item("Amount")

Hi Phil

try to format String.Format("{0:0,0}", dr.Item("Amount"));

 

[Mark Rae [MVP]]

I'm grabbing "Amount" from a DB with Decimal format. The outpul of
AmountL.Text comes up as 9999999.99 and I want to format this so it is
displayed as 9,999,999.99. Can someone help me with this simple task?

AmountL.Text = dr.Item("Amount")

AmountL.Text = dr.Item("Amount").ToString("#,##0.00")

 

[pvong]

Mark,
I'm getting this error message.
Input string was not in a correct format.
I'm trying to do this in VB.Net

 

[pvong]

This is almost perfect. It cuts off my pennies. How do I get it to include
the 2 digits after the decimal?

 

[Mark Rae [MVP]]

"pvong" <phillip*at*yahoo*dot*com> wrote in message

[top-posting corrected]

I'm getting this error message.
Input string was not in a correct format.
I'm trying to do this in VB.Net

AmountL.Text = Convert.ToDecimal(dr.Item("Amount")).ToString("#,##0.00")

 

[Alexey Smirnov]

This is almost perfect. It cuts off my pennies. How do I get it to include
the 2 digits after the decimal?








- Show quoted text -

{0:0,0.00}

 

[pvong]

PERFECT!!!!

Thanks!
Phil

{0:0,0.00}

 

[pvong]

Perfect! Thanks!

"pvong" <phillip*at*yahoo*dot*com> wrote in message

[top-posting corrected]

I'm getting this error message.
Input string was not in a correct format.
I'm trying to do this in VB.Net

AmountL.Text = Convert.ToDecimal(dr.Item("Amount")).ToString("#,##0.00")