Posted to microsoft.public.excel.misc

external usenet poster

Posts: 7

How to concatenate text & date

How do I combine paydate & 01/02/09?

=concatenate(A1,B1) formats the date as 35983.

I want the date to appear as 01/02/09.

--
AcctCA755

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
Using Concatenate function to generate text in Text Box	Mary S.	Charts and Charting in Excel	1	December 14th 05 08:55 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
concatenate text and date	Tara Keane	Excel Discussion (Misc queries)	2	February 11th 05 05:17 PM

All times are GMT +1. The time now is 02:23 AM.

About Us

"It's about Microsoft Excel"