ExcelBanter - View Single Post

Jithu

"Sandy Mann" wrote:

Press and hold the Ctrl key while you pess the semi-colon key ; then,
(without the Ctrl key being pressed) , enter a space then press and hold
both Ctrl & Shift while you press the full colon key :

This will enter the date then the time as a static entry.
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

Replace @mailinator.com with @tiscali.co.uk

"Jithu" wrote in message
...
Hi,

Is it possible to get the time value while entering data.

for example when i enter data(date) at 2.00 pm, the cell(same cell or in a
different cell) should capture the time of data entry. And it should be
static. so that in future i can know the time of data entry
Thanks in advance for help.

Jithu