View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ali Ali is offline
external usenet poster
 
Posts: 80
Default input date format "ddmmyyyy"

I'd like to input my date as "ddmmyyyy" . For example, if i input 12032008, i
should have 12/ March/2008.

However, my current setting turns out to be 3/Dec/2008. it's totally
up-side down.

Dear experts, thanks a lot !



--
Allen Phailat Wongakanit