View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Dennis Paul Dennis is offline
external usenet poster
 
Posts: 51
Default VLOOKUP return text not date

I am using VLOOKUP to return a date, however it returns the number of the
date, rather than the date. I know that Excel stores dates as numbers, hence
how do I get around this?