=Now() Format



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





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
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
Diff. in time 1
Criteria For SU<IF 5