I am trying to format the value of my data into currency.

You can format any field in the grid view/SQL table editor and use the ""C"" format string for a given field.
To format a field in the grid view component, set the ""Default For Columns Are Visible"" property to False. You will then have to manually call out the fields you want to display in the grid view and specify the column name and is visible = True property. From there, You can individually format each field using Microsoft String Formatting capabilities.