Inserting time with ctrl+shift+: always shows 00 for seconds

J

JimK

Whenever I use the shortcut ctrl+shift+: to enter the current time, th
seconds are always 00 instead of whatever the system clock shows.

I need the current, real-time seconds to show.

Is this possible?

Using Excel 2000
 
J

Jim Rech

I don't know of a way to modify how Excel does this. You could run a macro
instead of using that shortcut:

Sub InsertTime()
With ActiveCell
.Value = Now
.NumberFormat = "h:mm:ss"
End With
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top