| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conversion Ratio
Hi,
If the OP only intends to show this then your fractional format seems to be easiest solution. Another approach if he wants to use nominator and denominator later on: Insert my UDF NRN() from http://www.sulprobil.com/html/neares...al_number.html Select cells A1 and B1 together. Enter =NRN(PI(),999) as array formula (with CTRL + SHIFT + ENTER). Regards, Bernd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ascii conversion | Excel Discussion (Misc queries) | |||
| Calculation of Ratio | Excel Discussion (Misc queries) | |||
| Divide x/y should give Ratio x:y,How to express ratio in excel | Excel Worksheet Functions | |||
| How do I calculate and display ratio ( format 3.5:2) | Excel Worksheet Functions | |||
| Curency Conversion Dilemma | Excel Worksheet Functions | |||
Threaded Mode
