I have a column of my datagrid with the format set to "$0.00" so it displays as currency. The problem is if a user types $1.00 in the column it reverts back to the value it was previously. If they type 1.00 without the "$" then it works fine and will automatically add the "$". How can I make the column still accept the new value even if the new value contains a "$"? TIA