Thread: how do i enter date and time in cell without it changing
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default how do i enter date and time in cell without it changing
You have responses at your other post.

bete wrote:

I WOULD LIKE TO KNOW IF IT IS POSSIBLE TO HAVE A FORMULAE THAT HAS DATE AND
TIME IN IT IN ONE CELL AND IT STAYS ON THAT DATE AND TIME. I HAVE TRIED NOW()
BUT IT CHANGES WHEN THE COMPUTER CLOCK CLICKS OVER TO NEXT MINUTE AND HAVE
TRIED TODAY() BUT IT DOES NOT SHOW TIME

--

Dave Peterson
Reply With QuoteReply With Quote