Copy DDMMYYYYHHMMSS and Paste as Unicode Text
I have a promblem I've been trying to solve without success and wonder if someone could kindly assist?
RECORD_ID TIME_STAMP DELETE_FLAG ETC....
1 2014-12-05 10:11:06 N
The TIME_STAMP column is date and time formatted from a now() function. I need to copy all of my data and paste onto a new sheet as unicode text and then concatenate my results with a pipe delimiter.
At the moment, when I paste to a new sheet data in TIME_STAMP is just coming through as '41978.4290821759'. If I format the columns it will show correctly, but when I concatenate my columns, concatenate decides on its own date format.
How can I resolve this?
Last edited by adriles; 12-05-2014 at 07:02 AM.
Reason: table formatting
Re: Copy DDMMYYYYHHMMSS and Paste as Unicode Text
I will add another part to the process using =TEXT(B2,"yy-mm-dd hh:mm:ss").
I will copy from this new cell which is text, rather than the original cell containing the date formatting.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By CAS123 in forum Excel General
Last Post: 11-13-2012, 09:10 AM
By windunce in forum Excel General
Last Post: 03-09-2010, 03:36 PM
By rr1050 in forum Excel General
Last Post: 01-12-2009, 03:05 AM
By sheva in forum Excel General
Last Post: 08-31-2005, 12:05 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1