ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel static current date/time problem (https://www.excelbanter.com/excel-worksheet-functions/19925-excel-static-current-date-time-problem.html)

hpmted

Excel static current date/time problem
 
To insert static current date and time Ctrl+ and Shift+ are supposed to work.
They have no effect when I use them. I'm using an IBM laptop.

Is there another way to put in a static date and time?

Trevor Shuttleworth

You may have missed a character

ctrl+colon for time (or ctrl+shift+semicolon)
ctrl+semicolon for date

regards

Trevor


"hpmted" wrote in message
...
To insert static current date and time Ctrl+ and Shift+ are supposed to
work.
They have no effect when I use them. I'm using an IBM laptop.

Is there another way to put in a static date and time?





All times are GMT +1. The time now is 08:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com