Forum Discussion

sandra1019's avatar
sandra1019
Copper Contributor
Jan 07, 2023

excel 365

Hi, 

 

I have a column for dates and a column for times in my spreadsheet. Everything was fine and then suddenly it all turned into numbers and I can't change them back. I have already tried using the format box and I looked in options but don't find anything to help me. I need to change them back. Please help!

 

Thanks,

Sandra

excel
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jan 07, 2023

    sandra1019 

    If the columns now contain numbers you should be able to format them as date or time.

    Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources