Excel Format changing automatically after 12Days of Dates

[Rampage598]

I am trying to print the dates from 1 march to 16 march it's giving me properly dates till 12 march in "MM-dd-yyyy" format but after 12th of march its giving me wrong format....
I tried to remove the time manually but its giving me in the format of "dd-MM-yyyy" actually i want all the dates from 1 march to 16march in the form of "MM-dd-yyyy"

Is there any macro code to delete all the time after 12th march?

 

[gordsky]

View attachment 60188
I am trying to print the dates from 1 march to 16 march it's giving me properly dates till 12 march in "MM-dd-yyyy" format but after 12th of march its giving me wrong format....
I tried to remove the time manually but its giving me in the format of "dd-MM-yyyy" actually i want all the dates from 1 march to 16march in the form of "MM-dd-yyyy"

Is there any macro code to delete all the time after 12th march?

how is that data entered into the cells? have you reformatted the cell itself?

 

[Rampage598]

how is that data entered into the cells? have you reformatted the cell itself?

Actually i am doing automation in Power automate....
This is my Input Excel sheet i am reading this entire data

and writing into the another excel sheet, in that i am using macro to change the format of this data to "MM-dd-yyyy"

 

[gordsky]

Actually i am doing automation in Power automate....
This is my Input Excel sheet i am reading this entire data
View attachment 60193
and writing into the another excel sheet, in that i am using macro to change the format of this data to "MM-dd-yyyy"

can you post the code you are using?

 

[Rampage598]

can you post the code you are using?

Actually there is no macro code for this.....
Can you tell me if there is any way to delete time from these dates?

 

[gordsky]

your post#3 said you are using a macro to change the date but now you say there is no code??
please be specific about what you are/are not doing and on which platforms. Are you trying to manipulate the date in excel or after exporting to automate