=Now() Format

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date and time difference 19
Change date format in Excel footer 2
Match Date/Time to Date list 4
Date and Time Conversion 3
Date format problems after csv import 2
Date Format 2
Finding Date in an overseas format 20
Merge date formats..... and more 1

Top