View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Sébastien[_2_] Sébastien[_2_] is offline
external usenet poster
 
Posts: 4
Default Converting Dates

Hi jer101,

To format the cells in that format:
-select the cells (or entire column)
-menu FOrmat Cell. The Format Cells dialog displays.
-in the Number tab, for 'Category', choose 'Date', then choose the format from the 'type' list box.
-Click OK

Regards,
Sébastien