How to change excel column to show date values instead of numbers

[preetith (preeti)]

Dear All,

posting again !!
I am searching for a way to change the excel column values from “numbers” to “Date values”. (ex: 41004 to 16/01/2019)
This happens because I have used filter data table and reduced the number of columns. The output data table is showing “numbers” instead of “dates”.

I am able to do this using the “text to columns” feature in excel manually. Is there an activity for the same ?

Please help
Preeti

[Emman_Pelayo]

You can convert the OLE Date (i.e. 41004) to a readable date value.

Check the solution here:

How to convert Integer to DateTime?

Hi guys, I want to know how to convert a number to datetime in Excel just like the feature Excel has does. For example, 43819 → 2019/12/20, 43803 → 2019/12/4. Thanks in advance!

Reference:

DateTime.FromOADate(Double) Method (System)

[preetith (preeti)]

Thank You. This helps.
I solved it by using “preserve format” while creating data table.

[Emman_Pelayo]

Good! Preserve format is slow tho if you are working on large set of data with various formattings (i.e. cell color, cell font).

You may also opt to change the excel column format from custom/number/general to text before reading the file if possible. The date value will not be converted to floating number when it is transferred in a datatable.