Hi to all, I have a web application that uses Gridviews to display currency data; it also saves said data to a sql database to be used later on. All data is used to work out new data so i need the decimal places to be saved no matter the length to the database, which is fine. Now my problem is i don't want to display said data to 10 decimal places in some cases. I would like to round off when displayed, but have the actual amount, decimal places and all, still in the Gridview (in case of a new save), kind of like an excel cell.
I don’t know if this is at all possible, if not does anyone have another solution for me?
Any help would be much appreciated. Thanks