currency formatting question

[joelk]

Can anyone help me format this so a $ sign shows up?

Dim thePaidAmount As String = item.AmountPaid
thePaidAmount = String.Format("{0:#######0.00}", thePaidAmount)

 

[Robert_Zenz]

thePaidAmount = Convert.Toint32(thePaidAmount).ToString("C2")

 

[joelk]

thanks robert,
I tried your code and got an error message saying

"Input string was not in a correct format"

what could be the deal bros?

 

[jmcilhinney]

Assuming item.AmountPaid is a numerical value it should be just:

thePaidAmount = item.AmountPaid.ToString("c")

That will use the current regional settings to find the default currency format, which will be a leading $ symbol and 2 decimal places by deafult in the US, Australia and various other places that use dollars. If you want to ensure US currency format even if the regional settings are different then you should create your own CultureInfo for the en-US culture and use its NumberFormat property.

 

[joelk]

it has been solved you squires! thank you for your help.