LibreOffice Tips and Tricks

From Free Knowledge Base- The DUCK Project
Revision as of 12:00, 18 January 2018 by Admin (talk | contribs) (Created page with "== Calc: Date Format and Partial Entry == If you highlight the column and press CNTL-1 a dialog with options appears. Make sure the language is set to English. When using Ex...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Calc: Date Format and Partial Entry

If you highlight the column and press CNTL-1 a dialog with options appears. Make sure the language is set to English.

When using Excel, a partial date entry such as MM-DD ie: 1-25 will automatically result in conversion to the configured format, for example MM/DD/YYYY or 1/25/2018. This does not occur by default in Calc.

Retrieved from "http://wiki.robotz.com/index.php?title=LibreOffice_Tips_and_Tricks&oldid=16380"