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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Format date in excel 2000 like '31st January 2005' (https://www.excelbanter.com/excel-discussion-misc-queries/32973-format-date-excel-2000-like-31st-january-2005-a.html)

Malcolm Agingwell

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?

JE McGimpsey

See replies to your earlier post.

In article ,
"Malcolm Agingwell"
wrote:

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?

All times are GMT +1. The time now is 04:03 PM.