--- In [email protected], Brian Wayne Marcotte
<[EMAIL PROTECTED]> wrote:
>
> Hello Jean,
>
> Saturday, August 4, 2007, 2:57:42 AM, you wrote:
> > The PPro Calendar pastes the date / time only into the clip
> > board and I was wandering how I would go about creating a snippet
> > entry using the *Keys command that calculates the current time and
> > date in this format ddd dd mmm yy h:mm so that I can paste it into the
> > Excel cell.
>
> > The formula that I am using in Excel is :=TEXT(NOW(),"ddd dd mmm yy
> > h:mm ")& " - " , which gives me this result : Sat 04 Aug 07 16:50 -
>
> If you open PowerPro's help file and look in the index there is a
subject: format a date or time.
>
>
> --
> Best regards,
> Brian
>
Thank you Brian
I've discovered in the *Keys command in the button "Enter keys to
send.Use button to select key or record keys." an entry {datelong}
and {time} and I have this in the box: {datelong} {time} - {space}
which pastes Sunday 5 August 2007 10:10:51 - into the Excel cell
which is what I wanted. Thanks Bruce.
However {datelong} uses the Regional setting in Control panel. The
question is how do add an entry to the entries when I click the button
that formats the date as above "ddd dd mmm yy h:mm" without altering
the settings in Control Panel as I may not have access to it at work?
Thank you
Jean
