| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format Concatenate function?
My goal is to combine 2 values that are calculated in their respective cells
into one string. What I have is the number '2' in cell A1 and the number '3 1/8' in cell B1. I want to come up with the text 2'-3 1/8" in cell C1. My problem is that the inches part of it comes out in decimals, not as a fraction, ie. I get 2'-3.0625" instead. What is the easiest way to solve this? I've got thousands of cells to convert. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONCATENATE And Date Format | Excel Discussion (Misc queries) | |||
| Vlookup, Concatenate, Format | Excel Discussion (Misc queries) | |||
| Format numbers returned in the function CONCATENATE | Excel Discussion (Misc queries) | |||
| Format numbers / Concatenate | Excel Discussion (Misc queries) | |||
| concatenate and format | Excel Worksheet Functions | |||
Threaded Mode
