How to return the date format to an excel cell?

Help
, ,
1

Hello,

I need to extract a column from an excel. These columns are dates and I need to sort them from least to greatest:

image

The problem I have is that when I remove them they change format and show the following:

image

How can I format the data so that it keeps the date view?
Someone knows something about it?

Thank you very much in advance.

2

Hi @Yur,

43704 it’s the value of the date. If you press ctrl + 1 in excel. It will show a pop up window.

image
Just click on the format that you like best. Let me know if this is what you’re looking for or if you’re actually trying to make your date a string.

3

Hi @rmunro

Thanks for the reply.

The solution you propose had already tried it.

I enclose the evidence in which the format change from Excel is shown:

image

Can you think of any other proposal?

Thank you.

4

@Yur,

Excel automatically formats the date values in order to prevent this you must change it to text format. You can archive this by using the text formula in excel. Also you can enter a ’ caracter and it won’t change since excel will now detect it like a string.
image

image