Hey I have the following issue after converting a csv into regular excel: some of the values (that are supposed to be amounts) , are there as dates, example 11.31 has been converted into Nov 31 BUT if I change the format to number of text then I get the 11628. What can I do? R...
I just need this as an additional option and don't want to change the default date formats. Thanks. Reply Alexander Trifuntov (Ablebits Team) says: 2020-07-02 at 8:29 am Hello Rajiv! You can save the workbook with your custom format as an Excel template. Then, based on this ...