>>>>BTW, see answers on your formatting question here
>>>>
>>>>http://forum.lessthandot.com/viewtopic.php?f=39&t=7043
>>>>
>>>>myvalues.ToString("$#0.00")
>>>
>>>This doesn't work

>>>RetVal += "<td>" + oReader("thisyear").ToString("{0:C}") + "</td>"

>>>and neither does this

>>>RetVal += "<td>" + oReader("thisyear").ToString("$#0.00") + "</td>"
>>>

I'd be happy with just commas.
>>
>>Ok, did you make it work?
>
>No, I took the question to NET forums. Both of the above attempts raise an error about casting between string and integer. DOesn't make any sense to me cause without the format code it works fine.

What is the type of ThisYear? Did you try to convert it to decimal first?

Please re-visit the above link for a sample.