input date format "ddmmyyyy"

[ali]

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 !

 

[macropod]

Hi Allen,

What function are you using to turn your number string into a date? It's a bit hard to tell you how to correct it without knowing
this.

Cheers

 

[Kassie]

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.

 

[JMB]

The short date format is determined by your regional settings in Contol
Panel. Undoubtedly, this regional setting is mm/dd/yyyy format. So when you
key in 12/03/2008, it is still interpreted as Dec 3, 2008 regardless of what
custom format you may have applied to the XL cell. Key it in accordance
w/the regional setting and use a custom XL format dd/ mmmm/yyyy to get the
desired format (or change the regional setting - but this is machine specific
so it could cause issues if others use your spreadsheet).

Another option if you literally want to type 12032008 and get 12/ March/2008
is to key in 12032008 (with the cell initially formatted as general), then
select your column of dates and click Data/TextToColumns, select delimited,
click next, uncheck all of the delimiter options, click next, select DMY from
format options and click finish. Then format your data w/ a custom format of
dd/ mmmm/yyyy.

 

[Niek Otten]

Hi Allen,

Look here:

http://xldynamic.com/source/xld.QDEDownload.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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