Todays date in Excel spreadsheet

  johnincrete 07:27 28 Jun 2009

With a single click or keyboard shortcut, I want to enter today's date in format DD/MM/YY in an excel spreadsheet.
Can anyone help please

  bremner 07:55 28 Jun 2009

Control + semi colon (Ctrl ;)

  mgmcc 07:58 28 Jun 2009

You can record a Macro to do this. Start recording a Macro, then type into a cell =TODAY() and press Enter. If necessary, format the cell to display as Date. Stop recording and allocate a keyboard shortcut to the Macro. (The date inserted will always update to *today's* date - it won't retain the original date.)

  mgmcc 08:00 28 Jun 2009

>>> Control + semi colon

That's even better! :)

  johnincrete 18:44 28 Jun 2009

Problem is I would want it to stay the same date as when entered. Can it be done?

  reddwarfcrew 18:52 28 Jun 2009

record the macro as described above but in addition record copying the cell and then doing a paste special and paste values.

  VoG II 18:57 28 Jun 2009

Easier method: right click the sheet tab, select View Code then copy the following and paste into the white space on the right

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Target.Value = Date
End Sub

Press ALT + Q to return to your sheet. Now, double click any cell to add a date that won't change.

  johnincrete 03:35 29 Jun 2009

Thanks, that's just what I want

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

Halloween Photoshop & Illustrator tutorials: 20 step-by-step guides to creating spook-tacular…

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?