Ok, this is very odd. I need some input from others here. The OP has some date fields that Excel knows are dates, but that it insists on displaying in General format even after I tell it to use some other format. Observe the attached screen shot:

1) In the formula bar at the top is "2006-5-31". This is how I know that Excel knows it's a date.

2) The selected cell, C5, says "38868"; Excel is displaying the date in General Format.

3) In the Format-Cells dialogue at the right is the format that I set for that cell. I saved that setting and the date's format did not change from General. Then I entered the dialogue again, and it's still set to dd-mmmm-yy; Excel didn't change the format to anything else, it's simply ignoring it.

Attached Images

x.png (79.5 KB, 15 views)