SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-3375646%22%20slang%3D%22en-US%22%3EI%20want%20to%20keep%201-5%20showing%20like%20that%20and%20not%20change%20to%20date%20format!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3375646%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20keep%201-5%20and%20any%20other%20variation%20of%20that%20to%20stay%20the%20way%20it%20is%20and%20not%20change%20to%20date%20format%20but%20it%20keeps%20doing%20it%20and%20it%20is%20extremely%20frustrating.%20Can%20someone%20please%20help%20me%20ASAP!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETHANK%20YOU!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3375646%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3375664%22%20slang%3D%22en-US%22%3ERe%3A%20I%20want%20to%20keep%201-5%20showing%20like%20that%20and%20not%20change%20to%20date%20format!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3375664%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1390350%22%20target%3D%22_blank%22%3E%40Ashish1995%3C%2FA%3E%20Either%20format%20the%20cells%20where%20you%20want%20to%20enter%20such%20values%20as%20Text%20before%20you%20start%20entering%20them%2C%20or%20prefix%20the%20values%20with%20a%20single%20straight%20quote%20'.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3375682%22%20slang%3D%22en-US%22%3ERe%3A%20I%20want%20to%20keep%201-5%20showing%20like%20that%20and%20not%20change%20to%20date%20format!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3375682%22%20slang%3D%22en-US%22%3EOMG%20thank%20you%20so%20much!%20this%20has%20been%20annoying%20me%20for%20a%20while%20now.%20Thank%20you%20so%20much%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E
New Contributor

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!

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

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

OMG thank you so much! this has been annoying me for a while now. Thank you so much