Can someone help me? I have cell "C1" reserved for date and "C2" for time. I want to put formula in cell "C1" that if there is number in cell "C5" then place today's date in "C1" and time in "C2" for current time. I want to copy this from "C1" to "G1". If I typed in formula today() and it gives me what I want but when I open this file next day it puts that day's date. I want the date to stay when I entered number in "C5". Please help me! Thank you.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Dates & Time 1
- Thread starter xsubzeroz
- Start date
- Thread starter
- #3
- Thread starter
- #4
-
1
- #5
Seems like you are in a rush and Geoff is probably busy: so, what Geoff mean is once you have got the dates and the times, what you need to do is highlight those cells, go to Edit, Copy; then Edit, Paste Special, Values.
You can also enter the date and time manually without using the function:
Date CTRL/;
Time CTRL/: (CTRL/SHIFT/
You can also enter the date and time manually without using the function:
Date CTRL/;
Time CTRL/: (CTRL/SHIFT/
- Thread starter
- #7
Thanks a lot! Date CTRL/;
Time CTRL/: (CTRL/SHIFT/
These commands were very helpful. I still didn't get answear for my initial question. Is it possible to have formula in various cells to put date when you enter number one cell below and then save. When opened again the date before to stay, and now you enter number under another cell and display current date. I have worksheet that I have some people to fill out (put numbers) and I want it to show dates when they entered numbers but I don't want these dates to change. This worksheet is for month or more period of time so there will be different dates. Thank you for help again.
Time CTRL/: (CTRL/SHIFT/
These commands were very helpful. I still didn't get answear for my initial question. Is it possible to have formula in various cells to put date when you enter number one cell below and then save. When opened again the date before to stay, and now you enter number under another cell and display current date. I have worksheet that I have some people to fill out (put numbers) and I want it to show dates when they entered numbers but I don't want these dates to change. This worksheet is for month or more period of time so there will be different dates. Thank you for help again.
- Thread starter
- #8
I still didn't get answear for my initial question. Is it possible to have formula in various cells to put date when you enter number one cell below and then save. When opened again the date before to stay
The only way you would be able to keep the date would be to hoghlight the cells with current date and time and go Edit,Copy,Edit,Paste Special,Value.
You could write a macro to do that, but there is no automatic way to save the current date and time without doing one of the two steps above (that is copy, paste or write a macro)
The only way you would be able to keep the date would be to hoghlight the cells with current date and time and go Edit,Copy,Edit,Paste Special,Value.
You could write a macro to do that, but there is no automatic way to save the current date and time without doing one of the two steps above (that is copy, paste or write a macro)
- Thread starter
- #10
Thanks a lot for letting me know this. I never wrote macro and if it's not very hard could you please help me to do this (Walk me through). I made this worksheet for operators and would like to make it as simple as possible, I want to save them from inputting date and time when they enter number. If you could help me I really appreciate.
- Status