View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Stop dates from showing as numbers - when formated as dates

Reformat the cells. Select a cell above October that shows dates correctly
and use the Format Painter (looks like a paintbrush) to format the October
cells

By the way: it is in "Formula Bar" that you are seeing 10/1/2008
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"JR" wrote in message
...
I have an on-going spread sheet for PO's each mo a new sheet is created.
In
October the columns that should be dates shows in the toolbar as a date -
but
on the sheet it shows as a number (10/01/2008 shows as 39722). The cells
are
formatted as dates.

Thank You