ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Date (https://www.excelbanter.com/excel-discussion-misc-queries/23027-date.html)

cesario

Date

How do I auto insert the date on XL worksheet? There seems not to be an icon
or drop down.

Jason Morin

Hold the <Ctrl key down and press the colon/semicolon key.

HTH
Jason
Atlanta, GA

"cesario" wrote:

How do I auto insert the date on XL worksheet? There seems not to be an icon
or drop down.

RdB

cesario wrote:
How do I auto insert the date on XL worksheet? There seems not to be an icon
or drop down.
=today()

All times are GMT +1. The time now is 02:15 AM.