How to retrieve formatted text of a grid cell

[CamThach]

I select values from the database and display them in a grid but first I apply formatting to the values. So from the database I may get the value 5236.2389 but the grid may display $5236.24 due to my formatting.

What I want to do is retrieve the value that is displayed in the grid ($5236.24). All efforts so far of trying to access the data either from the dataset or the datagrid will yield the 5236.2389 value and not the formatted value.

Thanks in advance.

[Administrator]

Try:

string formattedText = this.grid[row, col].FormattedText;