Home |
Search |
Today's Posts |
#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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |