How can you return the formatted value displayed in a given cell (I know how to return the unformatted value).
What do you mean by formatted value? Generally, each cell contains an editor that is based on the data source. You can control the format of the values when the editor is not in edit mode using the Format property.
You can refer to MS' documentation on some default format strings.