Forum Discussion

Ashish1995's avatar
Ashish1995
Copper Contributor
May 14, 2022
Solved

I want to keep 1-5 showing like that and not change to date format!

Hi everyone,

 

I want to keep 1-5 and any other variation of that to stay the way it is and not change to date format but it keeps doing it and it is extremely frustrating. Can someone please help me ASAP!

 

THANK YOU!

  • Ashish1995 Either format the cells where you want to enter such values as Text before you start entering them, or prefix the values with a single straight quote '.

  • Ashish1995 Either format the cells where you want to enter such values as Text before you start entering them, or prefix the values with a single straight quote '.

    • Ashish1995's avatar
      Ashish1995
      Copper Contributor
      OMG thank you so much! this has been annoying me for a while now. Thank you so much 🙂

Resources