That solved the problem, thanks!!!
Replying to Expert Skills Excel 2016 Session3-14 Common Time Functions
Posted 01 March 2018 - 07:38 PM
Posted 28 February 2018 - 02:17 PM
I'm guessing that the problem is that instead of typing NOW you have typed NOW + <Enter Key>
Here are the five steps listed in the book:
Posted 27 February 2018 - 08:36 PM
I didn't see this problem entered before so if this is a duplicate question I apologize.
Lesson 3-14 Understand common time functions and convert date serial numbers to decimal values.
Step 1 Type current date and time into cell A15
Step 2 Click on cell B15
Step 3 Type =NOW
Whenever I clicked in B15 and entered =NOW, I kept getting a #NAME error. No matter what cell I clicked in I got that error.
The only way I could get it work was to enter +NOW()
Did I miss something?