::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

If you want a particular format when converting numbers to text, you can
specify the format in the TEXT function.
Instead of '1st Ext Calcs'!C16, use text('1st Ext Calcs'!C16,"# ?/?").
BTW, you can use & instead of CONCATENATE to save some typing. Instead of
CONCATENATE(A,B,C), use A&B&C.

"danjones" wrote:


::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

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

try this form where D14 and E14 are to be concatenated

=CONCATENATE(TEXT(D14,"# ??/??")," x ",E14)


--
duane


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