Question description:
This user has given permission to use the problem statement for this
blog.
Do I have to pay for a solution ? I just wasted time with another help desk that asked for $46 for an answer. If that is the case, thanks anyway.
Solved by X. U. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
27/03/2018 - 06:31
Hi there
User
27/03/2018 - 06:34
I am trying to change the dates in a column to show: today's date and current time. This info should be static and the cell. l should populate as I tab over it. HELP
Excelchat Expert
27/03/2018 - 06:35
I really apologize regarding the payment that was asked to you, we are investigating on that
Excelchat Expert
27/03/2018 - 06:36
Sure, i will help you with this issue in excel
User
27/03/2018 - 06:36
It was not your website. It was another website. I am just looking for free online help. Can you help ?
Excelchat Expert
27/03/2018 - 06:37
Yes i will surely help you
Excelchat Expert
27/03/2018 - 06:37
Can you share me a sample worksheet
Excelchat Expert
27/03/2018 - 06:37
So that we both can have a better evaluation to the issue
User
27/03/2018 - 06:37
I cannot. It is proprietary to the company.
Excelchat Expert
27/03/2018 - 06:38
okay will give you the for formula for todays date and time in excel, will that be good
User
27/03/2018 - 06:38
OK
Excelchat Expert
27/03/2018 - 06:38
So the formula is =NOW()
User
27/03/2018 - 06:39
The bracket is for ??
Excelchat Expert
27/03/2018 - 06:39
just copy it to any of the cell and you will get todays Date and time
User
27/03/2018 - 06:39
Will it stay static (unchanging from day to day) ??
Excelchat Expert
27/03/2018 - 06:39
yes the whole thing you have to copy =NOW()
User
27/03/2018 - 06:40
Thank you sooooooo much - you have saved me a lot of time. I will put you in speed dial for the future.
Excelchat Expert
27/03/2018 - 06:41
well after getting the date and time you can paste it as values to make it static
User
27/03/2018 - 06:41
How do I do that ?
Excelchat Expert
27/03/2018 - 06:41
Okay,
Excelchat Expert
27/03/2018 - 06:42
so to do that
Excelchat Expert
27/03/2018 - 06:43
just copy the date and time by pressing ctrl+C
Excelchat Expert
27/03/2018 - 06:43
and then press Alt + E+S+V
Excelchat Expert
27/03/2018 - 06:43
simultaneously One by one
User
27/03/2018 - 06:44
And this will allow me to tab over the cell and the current info will populate the cell ?
Excelchat Expert
27/03/2018 - 06:45
yes it can be redone
Excelchat Expert
27/03/2018 - 06:45
just paste the formula again there
User
27/03/2018 - 06:46
OK - I will try it. If I get in trouble, how do I fix it ?
Excelchat Expert
27/03/2018 - 06:46
there wont be any major trouble, with this formula
User
27/03/2018 - 06:47
I love your confidence - thanks again !! Signing off.
Excelchat Expert
27/03/2018 - 06:47
so dont worry, this is the best formula i have shared with you
Excelchat Expert
27/03/2018 - 06:47
Please do a valuable rating for me
Excelchat Expert
27/03/2018 - 06:47
that will help me a lot
User
27/03/2018 - 06:47
where is that ?
Excelchat Expert
27/03/2018 - 06:47
:)
Excelchat Expert
27/03/2018 - 06:47
you will get the options when you exit the session
Excelchat Expert
27/03/2018 - 06:48
Thanks for being in Got it Pro!
Excelchat Expert
27/03/2018 - 06:48
Have a nice day!
Excelchat Expert
27/03/2018 - 06:48
After pressing the end session button, you will get the options :)
Excelchat Expert
27/03/2018 - 06:49
If you really liked it then please put some good words for me :)
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
