Date conversion in Excel

bernard

New member
Hello! When importing an Excel file into Anatella, the date format has changed from a 'date' format to a 'number' format.

I would like to convert the date field in Anatella in order to obtain a date again in the yyyy-MM-dd format.

Could you please tell me which boxes to consider?image001.jpgimage002.jpg

Thank you for your support
 

Support

Administrator
Hello Bernard,

You can choose the columns in Excel that contain dates here:
2022-05-04.png

In your case, you just need to add column "A" to the list of columns that are dates.
 
Top