how do i enter date and time in cell without it changing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You have responses at your other post.
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
Click to expand...
 
You must log in or register to reply here.

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

Similar Threads

Daily Time Sheets with Rounding 1
Update cell value based on name and specific date 1
Date/Time 1
How do I call current computer time to a cell? 9
Time and Vlookup Problem 3
Date Time increment with additional condition of skipping weekends 13
Date and Time 8
Excel Vba to change displayed year automatically. 14

Back
Top