Way to merge data in 3 cells?

[Cam Hua]

Hello,

I have a raw data with the month in cell A1, Day in B1 and Year in D1.
How do I put them in one cell so it will read (month-Day-Year)? Thanks

Cameron

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[E Oveson]

Hi,
you could paste:
=DATE(D1,A1,B1)
in a different cell (e.g., A2)

then goto Format -> Cells -> click Number tab -> choose Custom and paste the
following under "Type:":
(m-d-yyyy)

 

[Dale Preuss]

Cam Hua,

If you want to use Excel to format the date through the number format:
=DATE(D1,A1,B1)

If you want the result to be text:
=A1&"-"&B1&"-"&D1

Dale Preuss

 

[Tom Ogilvy]

=Date(D1,A1,B1)

format cell as mm-dd-yyyy