Format date in excel 2000 like '31st January 2005'
 

Trying to set up field in Excel Data Source file so that the current date can
be input in letters typed in this format '31st January 2005'

Is it possible or am I stuck with dd/mmm/yy format?

Malcolm,

Why not just format it as you want, but input as standard dd/mm/yyyy. You
can't (easily) get the 1st 2nd etc, but a format of dd mmmm yyyy is quite
close.


--
HTH

Bob Phillips

"Malcolm Agingwell" wrote in
message ...
Trying to set up field in Excel Data Source file so that the current date
can
be input in letters typed in this format '31st January 2005'

Is it possible or am I stuck with dd/mmm/yy format?