Excel/LibreOffice Calc: Short entry of the date | TechBuzz

- Advertisement -

In the near future…

Did you know that you can also enter a date shorter than «15.6.22» in Excel? And in LibreOffice you can even customize it.

If you have to type a lot of calendar dates in Excel or in LibreOffice Calc, you might want to use the shortest form to save a little time.

Excel mini tip in advance

If today’s date is to be entered in a cell, simply press once after clicking on the cell Ctrl+Point (ctrl+Point). Make sure you use the punctuation dot (second right of the M) though. It doesn’t work with the decimal point of the numeric keypad. By the way, LibreOffice Calc does not know this abbreviation.

- Advertisement -

Also use when entering data Not the formula =TODAY(), because it enters the current date with every recalculation. If you entered «=TODAY()» in a cell on June 12, 2022, June 15, 2022 will appear there as June 15, 2022.

But how is it shorter now?

In Microsoft Excel you can use two different short forms of the date without the year, which also work via the numeric keypad: Both 15-6 as well as 15/6 is interpreted by Excel as June 15 of the current year.

Our input and Excel's interpretation of it
In Excel, you can type 15-6 or 15/6 to have it interpret that as a date in the current year
(Those: PCtipp.ch)

On the next page you can read how LibreOffice Calc reacts to this and how it can even be adjusted there.

- Advertisement -

Source link

READ  All of Marvel's Netflix shows are still uncensored on Disney Plus | TechBuzz
- Advertisement -
I am admin of techbuzz.asia blog & I provide tech-related news. As a part of my hobby, I make content related to technology and gadgets reviews too. I love to be a content creator apart from it, I am a full-time employee in an MNC company and manage blogs systematically. You can mail me at [email protected]

More from author

Related posts


Latest posts

Standing desk: What are the advantages of a standing desk for working and playing games ?! | TechBuzz

Problems with back pain and thinking about getting a standing desk? Wondering what are the benefits of a standing desk? Why are...

How to start a “Netflix party”? | TechBuzz

Netflix does not offer any option to launch a “Netflix party”, unlike Amazon Prime Video or Disney+. But an...

Everything you need to know about Wi-Fi 7 | TechBuzz

Wi-Fi 7 hasn't officially launched yet, but there's been a lot of work done on its specs. Here's what you need to know....

Want to stay up to date with the latest news?

We would love to hear from you! Please fill in your details and we will stay in touch. It's that simple!