View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Datahead Datahead is offline
external usenet poster
 
Posts: 1
Default how do I convert date format yyyymmdd to mm/dd/yyyy

how do I convert date format yyyymmdd to mmddyyy

I have rows of dates displayed as yyyymmdd (ie 20100131)

I want them displayed as regular dates (ie 01/31/2010)