cell display based on value

[richard]

I have a gridview cell that contains either 1 or 2 but that is not what I want displayed in the cell. I want a letter displayed lets say "X" or "Y". I have looked at the different cell formatting methods but they are all color or font based and not a substitution of value.

Any thoughts on this?

Thanks,
Richard

[richard]

i solved this by handling the conversion in the sql statement loading the data table.