| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
URGENT: Function Results in Fractions
::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 ExtCalcs'!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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Omit blank cells from function results | Excel Worksheet Functions | |||
| format cell based on results of vlookup function | Excel Worksheet Functions | |||
| clock | Excel Worksheet Functions | |||
| Using function results as parameters in another function | Excel Worksheet Functions | |||
| Urgent help needed: IF function | Excel Worksheet Functions | |||
Threaded Mode
