Sounds like the format has been changed. Highlight the affected area,
right-click, and choose Format. Now select one of the Data formats. Under
Custom there are many options to suit your preference.

"ashmoreB" wrote:

Hi,
i hope someone can help me.
I have a spread sheet which is used as a client list. In column C, we
usually have the date listed as MMM/YY (May-08). When i opened it this
morning all the dates were gone and in their place was a short list of
numbers (eg 40026). Up the top, next to the function symbol it shows the
correct date, but i have to click on the numbers to see the date.

How can i change it back to how it was previously. I'm not sure how this
happened.

thanks, B