>i want to show this format '###,###.##' in a list which retrieves numeric values from a field but it triggers an error how do I do this?

I believe that you can replace # with 9.

HTH