When copying from "date" cell to "general" cell, how to keep date.

L

Lisa from Aspen

An Excel question for you: when I try to copy data from a "date" formatted
cell over to a concatenate formula in a "general" formatted field, it
transfers the data over as the boolean value. This is causing endless
headaches because I am trying to upload the information into our financial
software. Do you know a solution for this?
 
P

Peg

I think you mean the date comes over as the serial value.
If not, this may not be right. In the concatenate
function, embed the Text function. ex: A1 has 5/16/2004,
B1 has "TEST" in it. C1 formula would be =concatenate
(TEXT(A1,"mm/dd/yy"),";",B1). The result would be
5/16/2004;TEST.
 
T

Thanks Peg!

WOW! Thanks for the quick response and excellent solution! You solved a
problem I have been dealing with for months. I greatly appreciate it!
 
Top