Why can't I format text in a DataGrid? I'm trying to display currency values such as $1.50 but it's coming out as 1.5 even though I have that column formatted as Currency?

Even the data is formated as currency in the database so I don't understand why the numbers are showing as regular integers in the DataGrid and not currency..

Any help would be appreciated..

Dan