View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default How do I merge 2 cells to 1 when contents are numbers

=A1&"/"&A2

"traceyclarity" wrote:

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)