Keeping the thousand separator when thousands

[elinorz]

Hi there,
I need to display numbers in thousands and to two decimal places. So for example 6,789,782 as 6,789.78
I have used the custom number formatting 0.00, which returns 6789.78. If I then format the cell as a number to add back the comma thousand separator, the whole number comes back.
Does anyone know how to write a custom Type so that I can keep the comma and still lose the thousands?
Thank you very much for any tips you can offer,
Elinor

 

[kevatarvind]

try below in custom format

#,#00.00,