Cells in the same column showing different date format

[Ramadan]

I have a problem to sort dates either from oldest to newest or vice versa
my worksheet with a table and tow columns "G" & "H" to add short dates, but when i try to sort dates I get a mess and dates are not sorted in the right way, when I treid to figure out the problem I found that when I select a date cell, there are some cells like "G272" showing date (in formula bar) as for example 05.11.2024 and other cell like "G274" showing the dates as 01.12.2024 as you can see in attached screenshots . while as you can see in the sheet itself both dates are showing as 24 not 2024
I Tried to copy and paste date format for all cells but still nothing changed in the formula bar

For your info if this might help - I was inserting dates manually first then I added a code to insert date automatically based on other cells value so there are some cells were filled manually and other through VBA

please let me know how to fix that

 

[arthurbr]

This is probably due to the fact that your dates are not real dates but text. Remove the manual alignment of the G and H columns. If the contents are left-aligned, they are text. There are several methods in the forum to make real dates from text. See https://trumpexcel.com/convert-text-to-date-excel/ for some of these methods

 

[Ramadan]

This is probably due to the fact that your dates are not real dates but text. Remove the manual alignment of the G and H columns. If the contents are left-aligned, they are text. There are several methods in the forum to make real dates from text. See https://trumpexcel.com/convert-text-to-date-excel/ for some of these methods

Thanks for your reply but I'm sure that all cells formatting is set as date not text

 

[Peter_SSs]

Thanks for your reply but I'm sure that all cells formatting is set as date not text

The fact that the cells are formatted as Date does not necessarily mean the underlying values are actual dates.
Follow the post 2 suggestion about removing the (centre) alignment from columns G & H and see if all the values move left or right or some of each.
My guess is that cell G272 will become right-aligned and G274 will become left-aligned.

 

[Ramadan]

The fact that the cells are formatted as Date does not necessarily mean the underlying values are actual dates.
Follow the post 2 suggestion about removing the (centre) alignment from columns G & H and see if all the values move left or right or some of each.
My guess is that cell G272 will become right-aligned and G274 will become left-aligned.

Yes you were right - it works - sorry for not understanding the point of view - I though it means cell formatting like General, text, date..etc
Thanks for your help

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.