Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically match destination formatting? | Excel Discussion (Misc queries) | |||
Destination formatting 2000? | Excel Discussion (Misc queries) | |||
HDI change paste options default to "Match Destination Formatting | Setting up and Configuration of Excel | |||
Format date in destination cell | Excel Worksheet Functions | |||
Change Hyperlink Destination Folder | Excel Discussion (Misc queries) |