R Reno747 Nov 30, 2007 #1 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() ?
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() ?
D David Biddulph Nov 30, 2007 #2 If you could do without the seconds, Control-Shift-Colon (or, for date & time together, Control-Semi-colon space Control-Shift-Colon).
If you could do without the seconds, Control-Shift-Colon (or, for date & time together, Control-Semi-colon space Control-Shift-Colon).
P Peo Sjoblom Nov 30, 2007 #3 Copy and paste special as values or use VBA (macros) -- Regards, Peo Sjoblom
