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

Why not change the format?
--
David Biddulph

"GS1976" wrote in message
...
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


"GS1976" wrote in message
...
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