If you send me a document dated 01/12/2006, I will read that as Jan 12, 2006
when you meant 01 Dec 2006.

If I enter 1-3-6 or 1/3/6 (doesn't work with periods, keep bat handy) into a
cell formatted as "dd mmm yyyy" it appears as 03 Jan 2006. To anyone that
reads their document while typing an error is apparent. Depending on your
regional settings 1-3-6 input into a cell formatted "dd mmm yyyy" may appear
as 01 Mar 2006 but; if you read while typing and that isn't what you want it
is obvious.

Consider assigning a "Data" "Validation" message (appears when cell
selected) with the date format of your choice.
Lou

"Rookie 1st class" wrote:

Louisville slugger applied to knuckles of offending parties. Then Format date
column containing dates as "Custom" dd mmm yyyy (IE. 30 Nov 2006) to
alleviate confusuion for all.

"Heven" wrote:

10th March 2006
15.03.08
2001.04.30
feb 2006 23

how to change all the above date formats in to a single format as -
dd/mm/yyyy