ExcelBanter - How to make the current date appear when i click 'enter' in a cell

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to make the current date appear when i click 'enter' in a cell (https://www.excelbanter.com/excel-worksheet-functions/128309-how-make-current-date-appear-when-i-click-enter-cell.html)

Matt_07

How to make the current date appear when i click 'enter' in a cell

Im trying to make the date appear next to a particular job once i have
completed it. I just want the users to be able to click enter and the date
will appear. Any body know how
--
Matt

Roger Govier

How to make the current date appear when i click 'enter' in a cell

Hi Matt

Just press Ctrl + ; (that's Control + semicolon)

--
Regards

Roger Govier

"Matt_07" wrote in message
...
Im trying to make the date appear next to a particular job once i have
completed it. I just want the users to be able to click enter and the
date
will appear. Any body know how
--
Matt

All times are GMT +1. The time now is 08:23 AM.