format numeric values as comma delimited strings

Question

Hi How do I format numeric values as comma delimited strings? These data are returned to me as XML. I transform it using XSLT and present it as html. But I need to format these numeric values the way the client wants it. e.g. 12345 => 12345 1235.12345 => 1234.12345 13.3566 => 13.3566 132341.00 => 132341.00 I've been playing all day with FLOOR money string manipulation but I still can't find an answer to my problem. Any help would be greatly appreciated. Thank you very much.

Jan Montano · Answer

I've solved my problem. Thanks!

Jan Montano · Answer

THanks for the reply but I need to do this in sql. The problem with money is the style. It's limited. it has specific decimal places. I don't want to modify the decimal places in any way. I want it to be converted as is. I just need the comma separation and not modify anything else.

Gaurish Kumar · Answer

Hi Jan try this in the page string val = 132341.12456; if (val.Contains(.)) Label1.Text = String.Format({0:00.00####} double.Parse(val)); else Label1.Text = String.Format({0:00} int.Parse(val)); Hope this will help you

naura pax · Answer

you can use following sql query if it is in backend (sql server): CONVERT(varchar CONVERT(money YourFieldName) 1)