Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dispay two values in one cell with the / border separating them.
Is there a way to display two values in one cell with the / border separating
them? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dispay two values in one cell with the / border separating them.
pshofstetter wrote...
Is there a way to display two values in one cell with the / border separating them? Only in the sense of ="one thing"&" / "&"and another" No other way to do it since Excel only supports _one_ value per cell, so the closest you'll ever get is one text value possibly showing multiple other values. Or you could store one value in, say X99 and the other in Y100 and draw a diagonal line from the bottom-left corner of X100 to the top- right corner of Y99. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dispay two values in one cell with the / border separating them.
Format the cell with the diagonal border and outline border.
Using spaces, pad the cell contents until you get the look you want. Gord Dibben MS Excel MVP On Thu, 7 Jun 2007 08:50:01 -0700, pshofstetter wrote: Is there a way to display two values in one cell with the / border separating them? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separating Names in a Cell | Excel Discussion (Misc queries) | |||
Separating Names in a cell | Excel Discussion (Misc queries) | |||
Separating names from one cell | Excel Discussion (Misc queries) | |||
Changing the border of one cell s/n change the border of adjacent | Excel Discussion (Misc queries) | |||
separating items in a cell | Excel Discussion (Misc queries) |