Traditional Culture Encyclopedia - The 24 Solar Terms - Who knows the meaning of mdy, ymd, myd, ydm and dym in excel date options? What's the use of being short?
Who knows the meaning of mdy, ymd, myd, ydm and dym in excel date options? What's the use of being short?
In the past, the date of birth of employees was entered in excel. For the sake of simplicity, it was always in the format of "YYY-MM-DD", but the higher authorities required it to be in the format of "YYY-MM-DD", such as 20 13-08-27. Then the birth time of 1000 employees must not be changed manually. The method of data decomposition is faster. The options in ymd format are arranged in the order of year, month and day.
Extended data:
Excel is the first spreadsheet software that allows users to customize the interface, including fonts, text attributes and cell formats. The function of "intelligent recalculation" is also introduced. When the cell data changes, only the relevant data will be updated, while the original tabulation software can only recalculate all the data or wait for the next instruction. At the same time, Excel also has powerful graphic functions.
When Excel was first bundled into Microsoft Office in 1993, Microsoft redesigned the interface between Microsoft Word and PowerPoint to adapt to this extremely popular application program at that time.
Excel has supported Visual Basic for Applications (VBA) since 1993. VBA is a powerful tool, which makes Excel form an independent programming environment. With VBA and macros, you can automate manual steps. VBA also allows you to create forms to obtain information entered by users. However, the automation function of VBA also makes Excel the target of macro virus.
- Previous article:The custom of the Spring Festival is 300 words.
- Next article:When do you eat asparagus?
- Related articles
- Presiding speech series of insurance morning meeting 10 template.
- When cng vehicle is driving, the idle speed is unstable and the engine is turned off at low speed.
- Moxibustion in summer solstice solar terms
- The custom origin of winter solstice festival
- This poem about Jiang is very short.
- Which province is Shangqiu?
- When is the corn harvest time in Henan?
- Birthday query1992-11-30-0.
- Customs and changes of the Spring Festival
- Tian Gandhi zhi