One way

=CONCATENATE(TEXT('1st Ext Calcs'!C16,"# ?/?")," x ",'1st Ext Calcs'!C11)



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"danjones" wrote in
message ...

::I'm a builder and I'm trying to generate layout
sheets using Excel. I have every thing the way I want it so far except
for one problem. When I use the Concatenate function, it converts my
result into decimals . For example: =CONCATENATE('1st Ext
Calcs'!C16,\" x \",'1st Ext Calcs'!C11) is the simple function. The
result I want is \"217 3/4 x 96\" and it gives me \"217.75\" instead.
I've tried formatting the cells to fractions, but seems to have no
effect on the function. My references come up as fractions just fine. I
need to finish this by the end of next week. I need a response ASAP!!!
Thanks for your help.

Dan Jones::


--
danjones
------------------------------------------------------------------------
danjones's Profile:
http://www.excelforum.com/member.php...o&userid=33516
View this thread: http://www.excelforum.com/showthread...hreadid=533068