When I copy data from the data grid and paste it into an Excel spreadsheet, if there is a NULL value in the data, the NULL value is overwritten.
Make sure that the 'Include null text' option is selected in the Export window options. You can get to the Export window by right clicking in the data grid and select 'Export Dataset'. You will need to do an actual export in order to save the change to the options.
