Date Format

[zeldy]

I have a file with date format 01/01/2020
i want to change the format to 01/01/20--i change it
because i want to copy all the lines to another system that works in this format 01/01/20
but it returns to 01/01/2020
why i cant change it?

 

[AlanSidman]

It looks like it is formatted in Column C already. I don't see the issue. Please explain further your issue being very specific using your file and cells to illustrate what you have and then what you want. Your explanation in post 1 is to general.

 

[zeldy]

If you look at C2 you see 01/01/20
but look at the bar its 01/01/2020
so the other system that i am trying to copy --is getting 01/01/2020

 

[AlanSidman]

You will need to convert your value to text to get the source data to look like you desire. In excel, all dates are numbers that are one up from the point of 1/1/1900. What you see in an excel cell is how that numerical number is formatted. See how to do this --> https://www.ablebits.com/office-addins-blog/2015/04/08/convert-date-text-excel/