Good Day Experts!
I gave it a valiant effort but I am really out of ideas. I have a DataGrid with double data values in 5 columns as received from a DataTable. I do not have the DataGrid column formatted as currency.
I need to be able to iterate through the DataGrid and based on a string value in the first column put a $ or £ in front of the double value. Here is what I am trying:
Dim Amount As String = CStr(DataGridRow.Cells(4).Value)
DataGridRow.Cells(4).Value = "$" & Amount
Unfortunately I am getting an error --> Not a valid value for type decimal
It feels like the DataGrid is holding onto the type "assigned" from the DataTable but I am not sure.
Can you help with ideas?