G
Guest
If I type Sept... it auto filles September. How do I get it then, if I press
the space bar to offer me todays date?
Thanks
Kelvin
the space bar to offer me todays date?
Thanks
Kelvin
Beth said:The AutoComplete for dates has been a bit flakey for several versions. What
seems to work for me is after I complete the month, press Backspace to
remove the space after the month and press the Spacebar again. Then you
should see the AutoComplete tip for the current date. Another alternative is
to ignore the AutoComplete tip for the month, type it out, and when you
press the spacebar the AutoComplete tip will change and offer to complete
the current date.
Is there a way to create a keyboard shortcut that works to *directly*
insert the current date -- without calling up the date/time dialog box?
The best I can do is to have a shortcut key that brings up the dialog
box and then I need to click "OK" to insert the default date format.
Suzanne said:Alt+Shift+D inserts the current date, but as a DATE field. If you
immediately Ctrl+Shift+F9 to unlink it, you would get date text in the
format selected as the default in the Date and Time dialog.
djprius said:Suzanne said:Alt+Shift+D inserts the current date, but as a DATE field. If you
immediately Ctrl+Shift+F9 to unlink it, you would get date text in the
format selected as the default in the Date and Time dialog.
Suzanne,
Thanks. As I posted later, I found an alternate way to use shortcut
keys to enter the current date without using the mouse: I assigned
"insert date/time" command to a new shortcut key. This calls up the
date/time dialog box. The I press [Enter] to add the default date -- in
my case, the full month spelled out, date, and year -- into the text.
It does not require using the mouse.
David