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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i enter date and time in cell without it changing (https://www.excelbanter.com/excel-worksheet-functions/136215-how-do-i-enter-date-time-cell-without-changing.html)

bete

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

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

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

All times are GMT +1. The time now is 07:12 AM.