[WPS Academy] 2.4.8 Excel: Set the date formats in WPS Spreadsheet

Hi, glad to see you here. Today we'll learn 'Set the date formats ' in WPS Spreadsheet. Follow our Youtube channel, level up your office skills! WPS Office is a free all-in-one office suite which include Writer(Word), Spreadsheet(Excel), Presentation(PPT) and PDF. Tutorials are provided by WPS Academy, WPS Academy is aime at providing both beginning and advanced office tutorial.
Get more updated information, find us through other social media platforms

Hello, I got a trouble with WPS Spreadsheet. When I use ddmmyyyy format, I copy a date from Excel with ddmmyyyy format, but in WPS Spreadsheet it changes to mmddyyyy format. For example when copying 02-04-2023 (Day: 02, Month: 04) from excel and putting it to WPS it understands (Day: 04 and Month are 02). How I can fix it

[JinaPortabella]

Do you have a video of automatic timestamp?

[mezzokate]

How can I pull down months to autofill the column? like in Excel...

[MsRobertsala]

Does anyone know how to install In-Cell Date Picker Calendar? I can see how it is done in Excel but not in WPS spreadsheet

[kamil]

And yet it still use US date format in formulas. How to change that? How date is displayed is a secondary thing, what really matters is how handy the input is, and if it still use US format it's pointless.