ExcelBanter - Displaying ratio as number of times

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

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

- - Displaying ratio as number of times (https://www.excelbanter.com/excel-worksheet-functions/132740-displaying-ratio-number-times.html)

Julie

Displaying ratio as number of times

Some of our ratios calculate as times, such as some turnover ratios. How can
we make them display with a small x in front of the value?

Bernard Liengme

Displaying ratio as number of times

Custom format: "X " General or "x" h:mm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Julie" wrote in message
...
Some of our ratios calculate as times, such as some turnover ratios. How
can
we make them display with a small x in front of the value?

Teethless mama

Displaying ratio as number of times

="x"&A1

"Julie" wrote:

Some of our ratios calculate as times, such as some turnover ratios. How can
we make them display with a small x in front of the value?

All times are GMT +1. The time now is 08:02 PM.