ExcelBanter - how do I express a number as a ratio (4:1)

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I express a number as a ratio (4:1) (https://www.excelbanter.com/excel-worksheet-functions/141887-how-do-i-express-number-ratio-4-1-a.html)

Neil[_2_]

how do I express a number as a ratio (4:1)

I would like to have a CBR show up as a ratio expression not as a integer
value after the division. How do I do this?
--

Roger Govier

how do I express a number as a ratio (4:1)

Hi Neil

FormatCellsNumberCustom #.0 ":1"

--
Regards

Roger Govier

"Neil" wrote in message
...
I would like to have a CBR show up as a ratio expression not as a
integer
value after the division. How do I do this?
--

All times are GMT +1. The time now is 11:14 AM.