Copy a calculated date in EXCEL as text

M

martinPP

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?
 
J

Jon Peltier

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
 
S

Sheeloo

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...
 
L

Lori Miller

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.
Click to expand...

(another method is to copy the dates to notepad and back again.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How To Have A Cell Be Blank If... 2
how to calculate hrs flown in last one year 0
Compare formula result with text 2
comparing formula results with a cell 4
How do I calculate a person's age from date of birth and a date 2
Date Difference Calculations 1
Trailing 30 days sum calculation with excel 1
Calculating Dates From Text 3

Top