=Date(D1,A1,B1)

format cell as mm-dd-yyyy

--
Regards,
Tom Ogilvy

"Cam Hua" wrote in message
...
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!