Concatenate for Numbers?

M

Michelle

In column A of my spreadsheet is Start Date (01/01/04),
Column B is End date (01/10/04). Each rows contains
different start and end dates. I am attempting to tie
these two together without retyping 300 rows of data. I
need a single column for date range (01/01/04 - 01/10/04).

I attempted to use Concatenate, however, it only works
with text. Is there a formula that I can use to join
these two together.

Your assistance is apprecitated.

Michelle
 
F

Frank Kabel

Hi
use TEXT for this. e.g.
=TEXT(A1,"mm-dd-yyyy") & " - " & TEXT(B1,"mm-dd-yyyy")
 
Top