Formatting a GridView Column to show currency

Assuming you already have a GridView column from an Access database named, for example, "Price" that is just showing up as 433.50 and you want it to show up as $433.50, follow these steps:

1. In your Access database the Price format should be selected as a number of type currency.

2. In the GridView, expand the little arrow on the upper right, select Edit Columns, and highlight the Price column

3. In the Behavior section set htmlencode to False

4. In the Data section, for the DataFormatString type: {0:C}

5. Click OK, save, Preview in Browser

That should result in the data showing up like $433.50