Concatenate Problem

[rfurman1161]

HI Everyone,

I have a hopefully simple problem dealing with a seral date that
don't want to see. I have two worksheets, the first is a scratch shee
that data is entered (ie dates, man hours, etc) and the second is th
Invoice form. The invoice form gets all it's data from the "scratch
form. The problem that I'm having is I get a serial date displayed whe
I want to see the real date. Can anyone help me with this? Here is th
formula that seems to be causing the problem:

=CONCATENATE("Total Time ",Worksheet!$A$15," throug
",Worksheet!$A$42)

Pretty simple nad straight forward. There is a standard date in bot
cells, but on the Invoice sheet it displays the serial format and no
the date. Any ideas?

Ro

 

[Frank Kabel]

Hi
try something like
="Total Time " & TEXT(Worksheet!$A$15,"hh:mm" & "through " &
TEXT(Worksheet!$A$42,"hh:mm")

 

[Andy Brown]

Use e.g.

="From "&TEXT(A1,"mm-dd-yy")&" to "&TEXT(A2,"mm-dd-yy")

Rgds,
Andy

 

[Jason Morin]

Try:

="Total Time "&TEXT(Worksheet!$A$15,"mm/dd/yy")&"
through "&TEXT(Worksheet!A42,"mm/dd/yy")

HTH
Jason
Atlanta, GA

 

[rfurman1161]

Thanks for everyone that replied to my post. that workedd perfect

Ro