Paste Special/Values Only: by hand

jake · Newbie Joined: 01 Dec 2005 Posts: 2

I found a thread where someone else apologised that something like this was a repeat: the reply to him involved a macro, which I don't need. So, sorry again.
I have some dates which I've changed to dd-mmm-yyyy format through a user-defined format. I need to copy the data to a new workbook and Paste Special...in Excel using "Values Only" ...so the cell content not the original format is copied. (Next I save as csv for an upload elsewhere.) Is there a way to do this? I get blanks or numbers depending which Special alternative I select, or with just Paste (or with Special/Formula")I get the date as I want to see it, but the original format is still in the entry-field, so of course that's what goes to the csv. Other fields, including different derived ones, seem to be ok.

Thanks.

Villeroy · Posted: Thu Dec 01, 2005 8:04 am Post subject:

So you want 1-Dec-2005 in your csv, right?
Assumed your dates are in A, fill an extra column with
=TEXT(A2;"DD-MMM-YYYY")
and paste special (strings) over the original values. Then you may remove the extra column.

jake · Newbie Joined: 01 Dec 2005 Posts: 2

YESSSSS! Thanks a lot Villeroy. I've been doing this process for ages in Excel, and just couldn't spot a way in OO.