>Oopsss sorry, but yeah I mean when I want to enter -1,000,000.00 in the column, it only accepts it as -100,000.00
I don't know; did you specify the .InputMask property?
I normally avoid editing directly in grid, but for reasons that are not relevant here; it should be possible in principle.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)