Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a calculated date in EXCEL as text
I've calculated a date in Excel using a formula. I want to copy the result as
TEXT into another cell. How do I do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a calculated date in EXCEL as text
Copy it, then Edit Paste Special Value, then Edit Paste Special
Format (or Number Format). You can also right-drag the source cell onto the target, and choose the appropriate option from the dropdown that pops up when you release the mouse. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "martinPP" wrote in message ... I've calculated a date in Excel using a formula. I want to copy the result as TEXT into another cell. How do I do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a calculated date in EXCEL as text
with your date in A1 use this in B1
=TEXT(A1,"dd-mmm-yyyy") You can change "dd-mmm-yyyy" to the format you want... the way you FORMAT CELLS-Date... "martinPP" wrote: I've calculated a date in Excel using a formula. I want to copy the result as TEXT into another cell. How do I do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a calculated date in EXCEL as text
If you actually want the calculated dates copied in TEXT format, try this...
preformat the number format of the cells to copy to as TEXT. using the Office Clipboad (Edit menu), copy and paste the dates IN PLACE now select the new cells and choose Edit Paste Special as TEXT. (another method is to copy the dates to notepad and back again.) "martinPP" wrote: I've calculated a date in Excel using a formula. I want to copy the result as TEXT into another cell. How do I do this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a calculated date in EXCEL as text
Thanks for the help. I've now got it working.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot with calculated date | Charts and Charting in Excel | |||
Prevent text converting to date in copy&pasting tables | Excel Discussion (Misc queries) | |||
Copy Date to Text | Excel Discussion (Misc queries) | |||
How can I match a calculated date to closest date from a list? | Excel Worksheet Functions | |||
Totals calculated by date | Excel Discussion (Misc queries) |