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)

Got it! Ulodesk, I stumbled across this purely by accident, looking around for some setting that might be doing this to you, and at first when I found the right one I didn't even notice it had fixed the problem. Do this:

1) On the ribbon, go to Formulas.

2) In the fourth ribbon section, entitled "Formula Auditing", notice that option H, "Show Formulas", is highlighted.

3) Turn it back off.

When I mouseover that option, it says it's to "Display the formula in each cell instead of the resulting value". It also says the keyboard shortcut for this option is <Ctrl-`>; I expect you hit that keystroke accidentally without knowing what you did. At least, I know that several times I've accidentally hit keystroke sequences that did something unexpected, unwanted and ununderstood.

I've never noticed that Formula-Auditing section before; now that I'm looking, it seems to have some useful features. In fact, the only thing I've ever used in the whole Formulas bar is the Name Manager. Thanks for your question, Ulodesk; I foresee a fruitful exploration coming up.