Home |
Search |
Today's Posts |
#1
|
|||
|
|||
custom formatting ???/????
I would like to see a fraction of two numbers from two different cells
exactly as it is. measn the ratio of 2000 to 4000 as 2000/4000 in another cell. WIth the custom way of cell formatting ( ????/????) I am unable to see this kind of display. please write me about this issue |
#2
|
|||
|
|||
Hi,
Let's say A1 = 4000 and A2 = 2000 Choose a cell and write in the formula: = A1 & "/" & A2 The cell will show 4000/2000. Hope this is the think you were looking for. Regards, Peter -- http://blog.jausovec.net "DVR019" je napisal: I would like to see a fraction of two numbers from two different cells exactly as it is. measn the ratio of 2000 to 4000 as 2000/4000 in another cell. WIth the custom way of cell formatting ( ????/????) I am unable to see this kind of display. please write me about this issue |
#3
|
|||
|
|||
I think the OP requires only the format, and not the value to be changed. By
using the formula below, you will no longer be able to use it in calculations as it will be treated as a string. Mangesh "Peter Jausovec" wrote in message ... Hi, Let's say A1 = 4000 and A2 = 2000 Choose a cell and write in the formula: = A1 & "/" & A2 The cell will show 4000/2000. Hope this is the think you were looking for. Regards, Peter -- http://blog.jausovec.net "DVR019" je napisal: I would like to see a fraction of two numbers from two different cells exactly as it is. measn the ratio of 2000 to 4000 as 2000/4000 in another cell. WIth the custom way of cell formatting ( ????/????) I am unable to see this kind of display. please write me about this issue |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom formatting | Excel Discussion (Misc queries) | |||
custom cell formatting | Excel Discussion (Misc queries) | |||
Custom Formatting a number | Excel Discussion (Misc queries) | |||
Custom Number formatting | Excel Worksheet Functions | |||
Custom formatting | Excel Discussion (Misc queries) |