This might sound really strange, but I have an application that exports a table of numbers to Excel, and some of these numbers might be NULL or blank. I need to display a dash (-) in place of the blank cells without actually setting the value of the cell to a -. This is because I might perform calculations on these cells and cannot have non numeric values, although blank cells are acceptable. Now I need to set the format of these numbers IN THE APPLICATION to an excel format, so that they will carry over the format when the data is exported.
Can anyone advise me on any format string to display a blank / empty cell to display a "-" ? Any advice is greatly appreciated.
Can anyone advise me on any format string to display a blank / empty cell to display a "-" ? Any advice is greatly appreciated.