Forum Discussion

Ashish1995's avatar
Ashish1995
Copper Contributor
May 14, 2022

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 ...
  • HansVogelaar's avatar
    May 14, 2022

    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 '.

Resources