May 20 2021 12:21 PM
May 20 2021 12:36 PMSolution
Select the cell with the =NOW() formula.
Press Ctrl+1 to activate the Format Cells dialog.
Activate the Number tab.
Select Date in the Category list.
Scroll through the Type list to see if there is a format you like.
If there is, select it and click OK.
If not, select the nearest one, then select Custom in the Category list.
You can edit the format code in the Type box to your liking. For example:
m/d/yyyy h:mm AM/PM
for something like 5/20/2021 9:36 PM
Then click OK.