| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Date to Text
I have a long row of dates that are formatted as Date.
I want to copy and past them into a blank cell as text and have them still look like dates (10/25/07) not long numbers. -- Thanks from the top of my little pointed head |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Date to Text
Insert a helper column and then place the following formula in the newly
minted column =TEXT(A1,"mm/dd/yyyy") Copy the formula down the column as far as necessary. Copy the entire column that has the converted dates and the click EDIT in the menu and select PASTE SPECIAL. Click the VALUES option button and click OK and your formulas are now just the results of the formula. Adjust the cell address and date format to fit your current requirements. -- Kevin Backmann "knowshowrosegrows" wrote: I have a long row of dates that are formatted as Date. I want to copy and past them into a blank cell as text and have them still look like dates (10/25/07) not long numbers. -- Thanks from the top of my little pointed head |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Date to Text
Copying and pasting will not turn them into text nor change the underlying
serial number uses for dates. All I can see is a formula in an adjacent column or wherever you want the text dates to show up. =TEXT(A1,"mm/dd/yyy") When done, copy then paste specialvaluesokesc Gord Dibben MS Excel MVP On Thu, 25 Oct 2007 13:19:00 -0700, knowshowrosegrows wrote: I have a long row of dates that are formatted as Date. I want to copy and past them into a blank cell as text and have them still look like dates (10/25/07) not long numbers. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i convert text to date (mm/yy text to mm/dd/yyyy date)? | Excel Discussion (Misc queries) | |||
| copy text box input into another text box automatically | Excel Discussion (Misc queries) | |||
| text box insert in Excel - text box lines print on second copy | Excel Discussion (Misc queries) | |||
| Copy text from text box to cell in another worksheet | Excel Worksheet Functions | |||
| I want to link, not just copy,Word source text to a text box in Ex | Excel Worksheet Functions | |||
Linear Mode
