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

That is most likely how you have set up your regional settings - MMM dd yyyy.
Try to change it to dd MMM yyyy, and see what happens.

--
Hth

Kassie Kasselman
Change xxx to hotmail


"ali" wrote:

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