Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ratio formatting
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? |
#2
|
|||
|
|||
maybe you used a formula in a helper cell?
=substitute(text(a1/b1,"??/??"),"/",":") uteowl wrote: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |