View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default How to? Date Function

On Thu, 17 Jul 2008 13:23:05 -0700, NervousFred
wrote:

I have a date in a table that is in the format 20080620. (Year Month Day all
together). Is it possbile to make execl convert this into a format I could
use in the DAY360 function?

Thanks!


Data/Text to Columns and select YMD for the format of that column.
--ron