ratio formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In an older version of Excel (and I can't remember which one) I was able to
do a numerical format for ratios x:xx. I don't remember what I did and no
longer have the workbook/sheets that contained the formatting. I am
currently using Office XP and Office:Mac 2003 -- I cannot figure out how to
format for ratios -- I don't want to use fractions (for esthetics) as my
display.

Any clues?
 
maybe you used a formula in a helper cell?

=substitute(text(a1/b1,"??/??"),"/",":")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT QUESTION?, Ratios 3
Help with normal distribution, generating ratios for bell-shape cu 5
How do I display comparitive ratios such as "16:2"? 4
Ratios with excel solver 2
Converting time formats in Excel 4
Copy/Paste without changing location references 2
Screen vs. Printed Aspect Ratio 1
Calculating a ratio based on letters in a field 5

Back
Top