Ron-

How do I get to the menu to change that specific column's options in 07 excel?




"Ron Rosenfeld" wrote:

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