In my program, I export datagridview results to an excel document, and the cells are formatted accordingly in the process
I've used the numberformat property with the value "$#,##.00" to format currency fields and "MM/DD/YYYY" to format short date fields. The formatting works, but in excel, the number format field in the ribbon reads 'Custom'. Instead, how do I make format it exactly to make it read 'Short Date' or 'Currency', instead of Custom?
I've used the numberformat property with the value "$#,##.00" to format currency fields and "MM/DD/YYYY" to format short date fields. The formatting works, but in excel, the number format field in the ribbon reads 'Custom'. Instead, how do I make format it exactly to make it read 'Short Date' or 'Currency', instead of Custom?