Forum Discussion
Ashish1995
May 14, 2022Copper Contributor
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 ...
- 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 '.
HansVogelaar
May 14, 2022MVP
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 '.
- Ashish1995May 14, 2022Copper ContributorOMG thank you so much! this has been annoying me for a while now. Thank you so much 🙂