date

Copper Contributor

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!