Forum Discussion

Gayle1965's avatar
Gayle1965
Copper Contributor
Oct 19, 2021

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. ...
Formulas and Functions
Gayle1965's avatar
Gayle1965
Copper Contributor
Oct 19, 2021

Riny_van_Eekelen the date is actually "date" formatted. I cannot change it to anything else.

 

 

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Oct 19, 2021

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.

  • Gayle1965's avatar
    Gayle1965
    Copper Contributor
    Oct 19, 2021
    I get TRUE
    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Oct 19, 2021

      Gayle1965Can you extract the date column from your file (a 100 rows or so), copy it to a new workbook and upload it here?

  • Gayle1965's avatar
    Gayle1965
    Copper Contributor
    Oct 19, 2021
    Hi 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

Resources