In Excel: Time Entering
 

How would I set up a Time format that every time I insert the Time
hh:mm:ss,It will not update automatically example: =NOW() ?

In Excel: Time Entering
 

If you could do without the seconds, Control-Shift-Colon (or, for date &
time together, Control-Semi-colon space Control-Shift-Colon).
--
David Biddulph

"Reno747" wrote in message
...
How would I set up a Time format that every time I insert the Time
hh:mm:ss,It will not update automatically example: =NOW() ?

In Excel: Time Entering
 

Copy and paste special as values or use VBA (macros)


--


Regards,


Peo Sjoblom


"Reno747" wrote in message
...
How would I set up a Time format that every time I insert the Time
hh:mm:ss,It will not update automatically example: =NOW() ?