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

change date formatting in destination cell
 

You can use a formula like:
=a1
or
=if(a1="","",a1)
or
=if(sheet1!a1="","",sheet1!a1)

But then you'll want to format that receiving cell:
Format|cells|Number tab
Date (and choose one of the prebuilt formats)

or use custom: m/d/yy or mm/dd/yy or whatever you want

Melody wrote:

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

--

Dave Peterson

change date formatting in destination cell
 

FormatCellNumberDate or Custom


Gord Dibben MS Excel MVP

On Thu, 21 Feb 2008 09:49:01 -0800, Melody
wrote:

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