Good Day Experts!
I have data that is defined in the SQL table as varchar that I am outputting to Excel. The data contains alpha code like RFDG as well as numerical code like 002. Since I need to keep the preceeding zeroes, I set the NumberFormat to the cell as "@". Now I get that little triangle in the corner of the cells that says "The Number in this cell is formatted as text..."
Is there anyway I can programatically get this to not show? The output is just for display purposes and there will be no totalling or manipulation by the Users.