Custom format as:
yyyy-dd-mm" -23.59.00"
Regards,
Alan
"CP" wrote in message
...
Hi Is there a formula to change a date in a cell such a as 01/12/2009 to
read
"2009-01-12-23.59.00" ? The -23.59.00 being fixed. Thanks.