Posted to microsoft.public.excel.misc

lschuh

external usenet poster

Posts: 39

concantenate text to date

I have 3 columns e2 month f2 day g2 year 5/15/7
How can I concantenate column e2+f2+g2 to get 5/15/07

thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Concantenate numeric fields	Pa Maher	Excel Worksheet Functions	10	January 17th 07 01:50 PM
Concantenate Help	Terri	Excel Worksheet Functions	4	March 31st 06 06:53 PM
Why won't Excel let me copy and paste my concantenate formula now	Jennifer	Excel Worksheet Functions	3	February 6th 06 04:14 PM
concantenate formula?	billygalkowski	Excel Discussion (Misc queries)	3	December 19th 05 08:19 PM
Concantenate Text with numbers with fixed form	sunslight	Excel Worksheet Functions	2	April 24th 05 01:39 AM

All times are GMT +1. The time now is 05:27 PM.

About Us

"It's about Microsoft Excel"