| View previous topic :: View next topic |
| Author |
Message |
livemusic
General User
Joined: 17 Feb 2008
Posts: 21
Location: Louisiana, USA
|
 Posted: Sat Dec 06, 2008 7:45 am Post subject: Show a number as a ratio, such as 3:1 |
 |
|
Can I have a number display as that number related to 1?
Such as, if the cell formula calculas and displays "3" in the cell, could I have it dsplay as "3:1?" Say, if it displays 17.04, it would show 17.04:1. |
|
| Back to top |
|
 |
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Sat Dec 06, 2008 8:08 am Post subject: |
|
|
You need a helper column. If your data is in column A, then in B1, you'd have =CONCATENATE(A1;":1") and copy that down column B.
David. |
|
| Back to top |
|
|
livemusic
General User
Joined: 17 Feb 2008
Posts: 21
Location: Louisiana, USA
|
| Posted: Sat Dec 06, 2008 8:40 am Post subject: |
|
|
| David wrote: | You need a helper column. If your data is in column A, then in B1, you'd have =CONCATENATE(A1;":1") and copy that down column B.
David. |
Thank you. It is displaying a number with something like 14 decimal places. Can I make it show only 2 decimal places (for the part preceding the ":1" via amending your formula?
EDIT: See next post, I found a solution.
Last edited by livemusic on Sat Dec 06, 2008 8:50 am; edited 1 time in total |
|
| Back to top |
|
|
livemusic
General User
Joined: 17 Feb 2008
Posts: 21
Location: Louisiana, USA
|
| Posted: Sat Dec 06, 2008 8:49 am Post subject: I got it |
|
|
=CONCATENATE(FIXED(B46;2);":1")
That seems to work. |
|
| Back to top |
|
|
hotpepper
Power User
Joined: 04 Dec 2008
Posts: 52
|
| Posted: Sat Dec 06, 2008 10:55 pm Post subject: |
|
|
You could also use a custom number format, something like:
0.00\:1 |
|
| Back to top |
|
|
|
