=Now() Format

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
Match Date/Time to Date list 4
Change date format in Excel footer 2
Date and Time Conversion 3
Date Format 2
Finding Date in an overseas format 20
Date format problems after csv import 2
Working with Date/Time 1

Back
Top