Concatenate Problem

R

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
 
F

Frank Kabel

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

Jason Morin

Try:

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

HTH
Jason
Atlanta, GA
 
Top