Posted to microsoft.public.excel.worksheet.functions

rd251

external usenet poster

Posts: 1

Concatenate a date and name

Each time I try to concatenate a date cell (ex 03/01/09) with a name file (ex
Johnson) the formul puts the date into its digital representative along with
the name (in the ex the result is 39508 Johnson). Is it even possible to
combine the two files? Any assistance would be greatly appreciated.

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
concatenate a date and a # ID	BillO	Excel Worksheet Functions	1	May 1st 07 05:51 PM
Date concatenate?	Hilton	Excel Worksheet Functions	2	April 19th 07 01:33 PM
Concatenate & Date	General Specific	Excel Worksheet Functions	2	September 25th 06 08:26 PM
I know how to concatenate ,can one de-concatenate to split date?	QUICK BOOKS PROBLEM-	New Users to Excel	1	July 26th 05 05:07 PM
Date CONCATENATE	AYPCN	Excel Worksheet Functions	2	March 10th 05 04:42 PM

All times are GMT +1. The time now is 02:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us