Can anyone make Excel do this?

[downhiller80]

I want to display just "February" because I don't know what date it'll be yet but I want it to internally store the value February 1st so that it will stay in the right place in the event of a re-sort.

Seb

 

[kranky]

Format the cell with a "Custom" format of mmmm.

 

[downhiller80]

cheers kranky. I knew there was an obvious way of doing it that I'd overlooked!

Seb