Hello RFPCymba,

Thank you for contacting us and sharing this information.

Please note, we are making efforts to ensure all posts are addressed by an Infragistics expert. We believe that the other community members could benefit from this thread as well.

Please do not hesitate to contact us if you need any additional assistance.

Thanks Boris,

This is quite an old post.

FYI, the 'solution' I settled for was to use a string datatype in the datasource/grid, and handle the desired K/M substituton and number formatting in the code.

The ability to handle a 'before data type validation' event would however still be a useful enhancement. 

Note that there are similar 'solutions' in place for editing cells with datasource/grid datatype=datetime and where the existing cell value in the datasource = null or dbnull.  This results in Infragistics exceptions being thrown out of the  System.Windows.Forms.Application.Run() method or the System.Windows.Forms.Application.ThreadException event handler if defined.

Regards.