I have a GridView that shows 0.00 in columns. I would like those columns to show nothing. Is there a way to supress the 0.00 using the DataFormatString property setting? Thank you.

You can use the RowDataBound event to manipulate the cell data:

http://msdn.microsoft.com/en-us/libr...databound.aspx

Question: why don't you manipulate this data prior to binding it to the gridview? For example, if you are pulling the data from SQL Server why not modify the Sproc to return an empty string instead of 0.00?

hth.
-Doug

__________________
===============================================
Doug Parsons
Wrox online library: Wrox Books 24 x 7
Did someone here help you? Click on their post!
"Easy is the path to wisdom for those not blinded by themselves."
===============================================

Doug,

Rows in columns show good numeric data, user just do not want to see zeros.

This makes no sense:
Rows in columns show good numeric data

Columns do not contain rows (unless you have some sort of nested table), rows contain columns. Are you saying that the RowDataBound event won't work for you?

-Doug

__________________
===============================================
Doug Parsons
Wrox online library: Wrox Books 24 x 7
Did someone here help you? Click on their post!
"Easy is the path to wisdom for those not blinded by themselves."
===============================================

Doug, I followed you suggestion and edited column values in my stored procedure. Thank you.