| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
