URGENT: Function Results in Fractions

[danjones]

::I'm a builder and I'm trying to generate layou
sheets using Excel. I have every thing the way I want it so far excep
for one problem. When I use the Concatenate function, it converts m
result into decimals . For example: =CONCATENATE('1st Ex
Calcs'!C16,\" x \",'1st Ext Calcs'!C11) is the simple function. Th
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 n
effect on the function. My references come up as fractions just fine.
need to finish this by the end of next week. I need a response ASAP!!
Thanks for your help.

Dan Jones:

 

[Guest]

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.

 

[Peo Sjoblom]

One way

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



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[duane]

try this form where D14 and E14 are to be concatenated

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