function =
=CONCATENATE(Sheet2!A1,A2)

text displayed used to be:
[the correct text string, combining text from 2 fields)

it is now:
"=CONCATENATE(Sheet2!A1,A2)"

date =
07/06/2006

date displayed =
38904

thanks....


--
tonerowlabs
------------------------------------------------------------------------
tonerowlabs's Profile: http://www.excelforum.com/member.php...o&userid=36138
View this thread: http://www.excelforum.com/showthread...hreadid=559127