Thread: Dates
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default Dates

I want to format my date from 1/24/2006 to 1242006

Why do you want to use an ambiguous format?

The format is mddyyyy

But how would you know, for example, if

1122006, which is the same format, represents

Jan 12, 2006 (1/12/2006) or
Nov 2, 2006 (11/2/2006)


Won't the forced 2-digit day number control that? The last six digits are
always 2-digit day and 4-digit year... what ever is in front of that is the
month. Personally, if I had to do something like this, I would force the
month to 2 digits also.

Rick