NOW ()
This
function shows the current date and time. The result will be updated each time
the worksheet is opened and every time an entry is made anywhere on the
worksheet.
Best view in desktop mode.
|
|
A
|
B
|
|
1
|
Current Date & Time
|
|
|
2
|
2/19/2020 19:35
|
=NOW()
|
|
3
|
43880.81616
|
=NOW()
|
|
4
|
2/19/20 7:35 PM
|
=NOW()
|
|
5
|
Syntax
=NOW()
Formatting
The result will
be shown as a date and time. If it is formatted to show as a number the integer
part is used for the date and the decimal portion represent the time.
Shortcut Key for Formatting
Go to D2 cell, Press
Ctrl+1, and you will see new pop-up window like below:
In the left side
section, select date and right side section select the date & time format
you want to see in excel and click OK button.
No comments:
Post a Comment