Displaying number format in a grid

[mdav2]

I am trying to display the following number format in a grids text box: 9,999,999.99

I've set the format to 9,999,999.99 but that didn't work. I set the input mask to 9,999,999.99 with no format. That only works if you move over the value in the grid.

Anyone got an idea how to display the format?

 

[Mike Gagnon]

The inputmask refers to when the user inputs data in the textbox.
May I suggest you put 9,999,999.99 in both InputMask and Format of the Column rather than the textbox