How do I merge 2 cells to 1 when contents are numbers

traceyclarity · Jan 27, 2006

IThe formula for vconverting two text cells into 1 cell does not work on
numbers. I want to convert 2 cells into 1 cell for example currently cell1 is
666 and cell 2 is 333 I want the cell to look like this 666/333 (excel 2003)

Sloth · Jan 27, 2006

=A1&"/"&A2

Sloth · Jan 27, 2006

sorry, I should have read more clearly. I don't think this will be much help
to you.

dlw · Jan 27, 2006

=CONCATENATE(TEXT(A1,0),"/",TEXT(B1,0))

Sloth said:
sorry, I should have read more clearly. I don't think this will be much help
to you.

How do I merge 2 cells to 1 when contents are numbers

traceyclarity

Sloth

Sloth

dlw