You are reading a single comment by @Sam_w and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Sam_w
ChainBreaker
Hey hivemind
I am struggling with excel and was hoping someone could help. This is dumb, but i cannot get it sorted.
I have copied and pasted dates (from my bank statements on a pdf): It starts off 29 January 2021
and copies as 29 January 2021. Great. BUT some go from 30 January 2017 which swaps to 30/01/2017.
Anything in the dd/mm/yyyy format is not recognised as a date. And it is not possible to format that number. NOTHING ive done has worked.
So i have 2 sets of number ranges.
03 February 2021 - format that can be formatted and put into age sequence.
03/03/2015 - non formattable and seems to to be in the sequence of the day (ignoring the month and year)
23/05/2017
25/02/2015
*I have (obvioulsy) tried: Format Cell>Number>anything else, and that will remain as 30/01/2017
*I have tried to use the format painter from everywhere including both the working date as well as the other columns.
*I have tried changing the format to custom then back to something else.
*I have tried to protect and unprotect the sheet
Is there any reason why i cannot format it? All i want to do is sort it in cronlogical order.
Anyone ever have an unformatable field esp a date?