Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm trying to calculate a ratio then print the ratio in a report. The format
I want to use is 4.5:1. |
#2
![]() |
|||
|
|||
![]()
Always :1?
If yes, give it a custom format of: General":1" BKW wrote: I'm trying to calculate a ratio then print the ratio in a report. The format I want to use is 4.5:1. -- Dave Peterson |
#3
![]() |
|||
|
|||
![]() "BKW" wrote: I'm trying to calculate a ratio then print the ratio in a report. The format I want to use is 4.5:1. Thanks for your response Dave, but when I try what you suggest quotes are generated like this "General Number:1" instead of what I entered which was General Number":1". What am I doing wrong? Thanks |
#4
![]() |
|||
|
|||
![]()
I copied this:
General":1" and pasted into the custom format box and it worked fine. But I didn't notice the info in the subject of your post. I don't think my suggestion will work. BKW wrote: "BKW" wrote: I'm trying to calculate a ratio then print the ratio in a report. The format I want to use is 4.5:1. Thanks for your response Dave, but when I try what you suggest quotes are generated like this "General Number:1" instead of what I entered which was General Number":1". What am I doing wrong? Thanks -- Dave Peterson |
#5
![]() |
|||
|
|||
![]()
See Dave's post for proper syntax
General":1" (no "number") Note: this will only work for your number:1 Gord Dibben Excel MVP On Wed, 28 Sep 2005 07:57:03 -0700, BKW wrote: "BKW" wrote: I'm trying to calculate a ratio then print the ratio in a report. The format I want to use is 4.5:1. Thanks for your response Dave, but when I try what you suggest quotes are generated like this "General Number:1" instead of what I entered which was General Number":1". What am I doing wrong? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
new sheets by this pc cannot calculate formulas | Excel Discussion (Misc queries) | |||
cells will not calculate | Excel Worksheet Functions | |||
HOW DO I CALCULATE A RUNNING PERCENTAGE | Excel Discussion (Misc queries) | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions |