I have to keep track of the time and date that trucks hauling commodities
into our business. I would like to use the NOW function, but each time I do
all of the cells in that column change to the new time. What can I do and
can I create a Macro for this?

How about some keyboard shortcuts using the colon/semi-colon key?

<Ctrl < ;
Then <Space, then:
<Ctrl <Shift < :

Gives you date and time in same cell.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Sheryl" wrote in message
...
I have to keep track of the time and date that trucks hauling commodities
into our business. I would like to use the NOW function, but each time I
do
all of the cells in that column change to the new time. What can I do and
can I create a Macro for this?

Thanks so much! I knew I was probably making it harder than it was.

"Ragdyer" wrote:

How about some keyboard shortcuts using the colon/semi-colon key?

<Ctrl < ;
Then <Space, then:
<Ctrl <Shift < :

Gives you date and time in same cell.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Sheryl" wrote in message
...
I have to keep track of the time and date that trucks hauling commodities
into our business. I would like to use the NOW function, but each time I
do
all of the cells in that column change to the new time. What can I do and
can I create a Macro for this?