Date Stamp at a tap

[s6guy1]

I don't know if Excel has this functionality. What I am trying to do is to have Excel place a time stamp as part of a log. This is to be transfereable to my palm TREO through "Doc's To Go". Data entry on a Palm can be tough at times.
I'd just like to tap the cell and get the current time stamp. and not to have it update or change. This is to be just a log date and time. There could be upwards of 150 of these on a sheet, all different.
I've tried =now(). This really just gives me a date and time and will change with my computers clock.
Hope some of you Guru's can help.

Thanks

[Bob Phillips]

Ctrl-; does that for you.

Or you could try event code

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Target.Value = Format(Date, "dd mmm yyyy")
Target.Offset(0, 1).Select
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"s6guy1" <s6guy1.1zofpb_1133970607.3477@excelforum-nospam.com> wrote in
message news:s6guy1.1zofpb_1133970607.3477@excelforum-nospam.com...
>
> I don't know if Excel has this functionality. What I am trying to do is
> to have Excel place a time stamp as part of a log. This is to be
> transfereable to my palm TREO through "Doc's To Go". Data entry on a
> Palm can be tough at times.
> I'd just like to tap the cell and get the current time stamp. and not
> to have it update or change. This is to be just a log date and time.
> There could be upwards of 150 of these on a sheet, all different.
> I've tried =now(). This really just gives me a date and time and will
> change with my computers clock.
> Hope some of you Guru's can help.
>
> Thanks
>
>
> --
> s6guy1
> ------------------------------------------------------------------------
> s6guy1's Profile:
http://www.excelforum.com/member.php...o&userid=29441
> View this thread: http://www.excelforum.com/showthread...hreadid=491485
>

[JE McGimpsey]

If you want to automate XL to add the time stamp whenever your data is
entered, take a look here:

http://www.mcgimpsey.com/excel/timestamp.html

In article <s6guy1.1zofpb_1133970607.3477@excelforum-nospam.com>,
s6guy1 <s6guy1.1zofpb_1133970607.3477@excelforum-nospam.com> wrote:

> I don't know if Excel has this functionality. What I am trying to do is
> to have Excel place a time stamp as part of a log. This is to be
> transfereable to my palm TREO through "Doc's To Go". Data entry on a
> Palm can be tough at times.
> I'd just like to tap the cell and get the current time stamp. and not
> to have it update or change. This is to be just a log date and time.
> There could be upwards of 150 of these on a sheet, all different.
> I've tried =now(). This really just gives me a date and time and will
> change with my computers clock.
> Hope some of you Guru's can help.
>
> Thanks

[Danny@Kendal]

"s6guy1" <s6guy1.1zofpb_1133970607.3477@excelforum-nospam.com> wrote in
message news:s6guy1.1zofpb_1133970607.3477@excelforum-nospam.com...
>
> I don't know if Excel has this functionality. What I am trying to do is
> to have Excel place a time stamp as part of a log. This is to be
> transfereable to my palm TREO through "Doc's To Go". Data entry on a
> Palm can be tough at times.
> I'd just like to tap the cell and get the current time stamp. and not
> to have it update or change.

CTRL ; (enters the date)
followed by
SPACE
followed by
CTRL : (enters the time)

A quick browse through the help files doesn't seem to list anything which
inserts the date AND time in one go. There should be a way to insert the
current date/time into the current cell with a macro and then assign a
keyboard shortcut to it.

[Danny@Kendal]

"Danny@Kendal" <danny@removethisbit.ghpkendal.co.uk> wrote in message
news:ReKdnSGYBcIWjgrenZ2dnUVZ8qGdnZ2d@eclipse.net.uk...
> "s6guy1" <s6guy1.1zofpb_1133970607.3477@excelforum-nospam.com> wrote in
> message news:s6guy1.1zofpb_1133970607.3477@excelforum-nospam.com...
>>
>> I don't know if Excel has this functionality. What I am trying to do is
>> to have Excel place a time stamp as part of a log. This is to be
>> transfereable to my palm TREO through "Doc's To Go". Data entry on a
>> Palm can be tough at times.
>> I'd just like to tap the cell and get the current time stamp. and not
>> to have it update or change.
>
> CTRL ; (enters the date)
> followed by
> SPACE
> followed by
> CTRL : (enters the time)
>
> A quick browse through the help files doesn't seem to list anything which
> inserts the date AND time in one go. There should be a way to insert the
> current date/time into the current cell with a macro and then assign a
> keyboard shortcut to it.

Ah! Just found it.

Create the following as a macro

Sub insertDateTime()
ActiveCell.Value = Now()
End Sub

Then select it from your list of macros, choose 'options' and assign a
keyboard shortcut.

I've just tried it and it seems to work.