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

[Guest]

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?

 

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

 

[Guest]

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