View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peter Peter is offline
external usenet poster
 
Posts: 349
Default Dateformats.....

Greetings all,

Us date format: 01/10/2009 ( January 10th 2009)

1. I want it to convert to ISO 8601 standard: dd-mm-yy
2. I want the day number (Sunday Day 1)..

I am trying all kind formats..customs..regional settings...but it gives me
wrong results..so fora example...01 June 2009...returns Saturday...

Thanks!