Send to Excel. Export Null value, showing empty in .xls file, but showing '-' in .xlsx file
Send to Excel. Export Null value, showing empty in .xls file, but showing '-' in .xlsxfile, it is number column, I want it showed empty, so only export to.xls file?
Could you resolve this problem or how to set configuration?
@Davidqing1985 It will be nice to have one macro to change that with in xls file.
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful