View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default 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.