Posted to microsoft.public.excel.worksheet.functions

EllenM

external usenet poster

Posts: 78

Concatenate Dates

Hello,
I need help to concatenate a date field. For example, I'd like one of them
to say "Posted 1/12/2007". Instead I'm getting "Posted 39094".

Thanks in advance for your help.

Ellen

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
How to CONCATENATE two dates field together	Lisa	Excel Worksheet Functions	6	April 2nd 23 08:09 PM
Concatenate several dates and hide 1/00/00	Jeff	Excel Discussion (Misc queries)	5	July 7th 06 12:26 PM
Concatenate Dates	22140	Excel Discussion (Misc queries)	2	October 25th 05 10:32 PM
concatenate with dates	Ciara	Excel Discussion (Misc queries)	2	June 10th 05 11:50 AM
concatenate dates?	gavin	Excel Discussion (Misc queries)	2	April 5th 05 09:05 PM

All times are GMT +1. The time now is 07:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us