| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
converting decimals to fractions
using a formula to combine multiple cells. one of the cells has a fraction 5
1/4 . the results of the formula from the combined cells is converting the 5 1/4 to 5.25 how do I get the result of the formula to retain the 5 1/4 fraction. I have tried formating the cell but that dosen't seem to work. Using excel 2002 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting decimals into hh:mm | Excel Worksheet Functions | |||
| converting fractions to decimal | Excel Discussion (Misc queries) | |||
| How do I sort a column consisting of fractions, decimals, and who. | Excel Discussion (Misc queries) | |||
| Converting imported numbers to decimals (rather than /100) | Excel Worksheet Functions | |||
| Fractions to Decimals problem | Excel Discussion (Misc queries) | |||
Threaded Mode
