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?

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?

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?

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?

Copy a calculated date in EXCEL as text
 

Thanks for the help. I've now got it working.