date

%3CLINGO-SUB%20id%3D%22lingo-sub-2107701%22%20slang%3D%22en-US%22%3Edate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2107701%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20format%20'date'%20to%20show%20yy%2Fmm%2Fdd%20without%20the%20need%20for%20me%20to%20have%20to%20type%20the%20'%2F'%2C%20i.e.%20i%20just%20want%20to%20type%20the%20numbers%20using%20the%20num%20pad.%20HOW%20DO%20I%20DO%20THAT%3F%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I want to format 'date' to show yy/mm/dd without the need for me to have to type the '/', i.e. i just want to type the numbers using the num pad. HOW DO I DO THAT???

2 Replies
Hi,
which product is your topic about?
Hello, I assume you're talking about MS Excel. You can visit https://support.microsoft.com/en-us/office/format-a-date-the-way-you-want-8e10019e-d5d8-47a1-ba95-db... to see the options for the date formats. I hope it helps. Cheers!