Date field - Excel 2003

[Bob Matthews]

I have a date field which has a range of dates from 1850 - 1930
Each entry has dd mm yyyy
how do I
1) format all fields to read e.g. dd Mmm yyyy
2) sort successfully on all records

Bob M

 

[ICE]

Select the range you want to format.
Right click.
In the Number Tab you will find the field "date" and on the right side you
will find the format you need.

Hope it helps.

 

[Pete_UK]

Excel only recognises dates after 1st Jan 1900. If you have dates
before this you might like to try this link:

http://j-walk.com/ss/excel/files/xdate.htm

Hope this helps.

Pete