how do I get a current time using =TODAY() instead of 12:00 AM
Keith
To enter a static date use CTRL + ;(semi-colon)
To enter static Now time use CTRL + SHIFT + ;(semi-colon)
To get both in same cell with space between CTRL + ;
Let go of CTRL and hit <space then CTRL + SHIFT + ;
Format to dd-mm-yyyy hh:mm
Gord Dibben MS Excel MVP
On Mon, 26 Jun 2006 10:30:03 -0700, Keith
wrote:
I want the date and time to be static. =NOW( ) changes everytime I open the
worksheet.
"Toppers" wrote:
use =NOW()??!!!
"Keith" wrote:
In Excel, If I format a cell with date and time and enter =today( )
I get the correct current date and a time of 12:00 AM
Never the current time. How do I get the current time?
If I enter =NOW( ) I get the correct current time.
Thanks.
Keith
|