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?
TEXT into another cell. How do I do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
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...
=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...
(another method is to copy the dates to notepad and back again.)
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.)
M
martinPP
Thanks for the help. I've now got it working.