Posted to microsoft.public.excel.misc

Dazed and Confused[_2_] Dazed and Confused[_2_] is offline

external usenet poster

Posts: 14

Concantenate columns with dates and text

The first two columns in my spreadsheet are dates. The third is text. When
I try to concantenate, the dates turn into numbers.

Any advice would be greatly appreciated.
Thank you.

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 text to date	lschuh	Excel Discussion (Misc queries)	3	October 22nd 07 09:55 PM
Text to Columns not working correctly with dates in Excel 2007	AL123	Excel Discussion (Misc queries)	5	February 26th 07 11:44 PM
Concantenate Help	Terri	Excel Worksheet Functions	4	March 31st 06 06:53 PM
Concantenate Text with numbers with fixed form	sunslight	Excel Worksheet Functions	2	April 24th 05 01:39 AM
COUNTIF With Multiple Dates, Columns and Text	Shannon	Excel Worksheet Functions	4	November 26th 04 11:12 PM

All times are GMT +1. The time now is 04:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us