Hello Haessd,

haessd said:

How do I set the cell or column format to Text rather than General to get rid of the error???

I`m not sure that I understand well your issue, but if you export your grid`s content into Excel, you could specify your CellFormat using for example the code below:

 private void ultraGridExcelExporter1_CellExporting(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.CellExportingEventArgs e)
        {
            e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[3].CellFormat.FillPatternBackgroundColor = Color.Red;
            e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[3].CellFormat.FormatString = "@"; // Text
        }

Let me know if you think that I misunderstand your question.

Regards