Difference between revisions of "LibreOffice Tips and Tricks"
From Free Knowledge Base- The DUCK Project: information for everyone
| Line 2: | Line 2: | ||
If you highlight the column and press CNTL-1 a dialog with options appears. Make sure the language is set to English. | 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. | + | 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 because Calc doesn't recognize the dash as a date separator. This was not a problem in older versions (3.5x and earlier). |
| + | |||
| + | Tip: CTRL + ; will automatically enter the current date in the active cell. | ||
[[Category:Computer Technology]] | [[Category:Computer Technology]] | ||
[[Category:Desktop Software]] | [[Category:Desktop Software]] | ||
[[Category:Software]] | [[Category:Software]] | ||
Revision as of 14:10, 18 January 2018
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 because Calc doesn't recognize the dash as a date separator. This was not a problem in older versions (3.5x and earlier).
Tip: CTRL + ; will automatically enter the current date in the active cell.
