Date conversion in Excel

[bernard]

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?

Thank you for your support

 

[Support]

Hello Bernard,

You can choose the columns in Excel that contain dates here:

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