View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Melody Melody is offline
external usenet poster
 
Posts: 51
Default change date formatting in destination cell

I have a date cell that I want formatted "January 1, 2008"; I want to pull
that date into another cell to minimize error, but I want it to be formatted
"1/01/08" because of space limitations. I can't figure out how to change the
date format in my destination cell - is this even possible?

Thanks,
Melody

--
Philippians 4:6