=Now() Format

G

GS1976

The =now() formula returns the date and time in the following format:

mm/dd/yy hh:mm AM

I need to change the format to:

dd/mm/yy hh:mm AM
 
B

Bob Davison

Right click on the cell that contains the function and select format cells.

In the category window, select Custom.

Then modify the format in the line just under Type: on the right. Make it
say d/m/yyyy h:mm AM/PM
 
Top