View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default what is the difference between Now() and Today()

Now() includes the time as well as the date.

You would need to remove the formula to do that, and replace with the value.

Try Ctrl-; (semi-colon) in the cell.

--
__________________________________
HTH

Bob

"Mary" wrote in message
...
Both seem to change when you reopen the spreadsheet. I'd like the date I
create the worksheet to be saved and not updated everytime I reopen it.
Any
ideas?