| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
displaying fractions in a concatenate formula
If I have a formula that concatenates text and numbers, for example, =concatenate("The average of ",A1," and ",A2," is = ",(A1+A2)/2) and I want the formula to display the "(A1+A2)/2" part as a fraction. The values in A1 and A2 will be integers. Can this be done in a non-VBA way? I'm using Excel 2003. Thanks in advance, Dave. -- DavidObeid ------------------------------------------------------------------------ DavidObeid's Profile: http://www.excelforum.com/member.php...fo&userid=2238 View this thread: http://www.excelforum.com/showthread...hreadid=564534 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula result not displaying in cell | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| CONCATENATE text formula | Excel Worksheet Functions | |||
| How do you copy a cell formula down a column without displaying n. | Excel Worksheet Functions | |||
| formula is displaying as text rather than result. | Excel Worksheet Functions | |||
Threaded Mode
