I have exported a report from Access to Excel 2003 ... I have two questions
which would make my life much easier.

One - the date field is formatted mm/dd/yyyy - I believe since it was from
Access I am unable to format it differently as when I go to change date
format it does not work. The end result I am looking for is to record the
year from the date field and populate a separate cell with the year only in
it.

Two - the information is a list with various duplicate project ID's that i
have to count. For example, "If B2=x, count 1"


--
Alison