| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i enter date and time in cell without it changing | New Users to Excel | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| Enter date and time in cell | Excel Discussion (Misc queries) | |||
| how to enter date without using "/" each time? | Excel Discussion (Misc queries) | |||
| how to enter date without using "/" each time? | Excel Discussion (Misc queries) | |||
Hybrid Mode
