View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ashmoreB ashmoreB is offline
external usenet poster
 
Posts: 3
Default Please Help! Dates gone and list of number in it's place

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