View Single Post
  #7   Report Post  
Old March 19th 07, 12:22 AM posted to microsoft.public.excel.misc
Paul B Paul B is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 709
Default NOW() function that is un-changing

Cheese, like this,

Sub Enter_Now()
ActiveCell = Now

'if you only want to show time
ActiveCell.NumberFormat = "h:mm:ss"
End Sub

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Cheese" wrote in message
Thanks for your help.

How would I configure the macro to enter the =NOW() value into a cell

than the =NOW() function?

"Fred Smith" wrote:

Ctrl-; will enter the date.
Ctrl-: will enter the time.

If you want both, you have three options.

1. Use =Now(), but after it's entered, Copy it and Paste SpecialValues
2. Enter Ctrl-; in one cell, Ctrl-: in another, then add them together.
3. Record a macro which will insert the =Now() value in the selected



"Cheese" wrote in message
Is there a =NOW() type of function that records the "now" time of when

first enter it and doesn't update to the current date/time?

I'm trying to create a date/time log of certain events that displays

date and time in hh:mm:ss - I only need to be accurate within a few

but the point is that =NOW() wouldn't work.

Any suggestions would be appreciated.