Forum Discussion
Gayle1965
Oct 19, 2021Copper Contributor
Excel Date issue
Hi I have a column with date formatted as Thursday 13 May 2021 and want to change it in the next column as 13/05/2021. However it won't let me change it using the Category DATE under format cells. ...
Gayle1965
Oct 19, 2021Copper Contributor
Riny_van_Eekelen
Oct 19, 2021Platinum Contributor
Gayle1965 Let's say B1 contains your problem date. What do you get when you enter a the formula =ISNUMBER(B1) ? If the answer is FALSE, the cell contains a text and can thus not be formatted as a date. It needs to be a number.
- Gayle1965Oct 19, 2021Copper ContributorI get TRUE
- Riny_van_EekelenOct 19, 2021Platinum Contributor
Gayle1965Can you extract the date column from your file (a 100 rows or so), copy it to a new workbook and upload it here?
- Gayle1965Oct 19, 2021Copper ContributorHi I have tried to convert it to a number and it wont convert. All i can do is delete the date in the cell. I have a large document I want to convert to normal date without the day. regards Gayle