LauraL

Posts: n/a

Thanks, this works perfectly.

"Dave O" wrote:

Within the CONCATENATE() function, instead of referring to the date
cell alone, refer to it by nesting the TEXT() function. For instance:
if your date cell is A1 and you're concatenating it with cell B1, your
formula would look something like this:
=CONCATENATE(TEXT(A1,"mm/dd/yyyy"),B1)

You may need to change the arguments of the TEXT function to fit your
specific application.

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
Columns	FemIce	Excel Discussion (Misc queries)	1	September 28th 05 09:29 AM
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns	Sam via OfficeKB.com	Excel Worksheet Functions	4	July 14th 05 09:15 PM
Hidden Columns in Shared Workbooks	Rotary	Excel Discussion (Misc queries)	1	July 9th 05 12:28 AM
Cobining more than 30 columns of data with concatenate.	JT	Excel Worksheet Functions	11	May 29th 05 03:10 AM
Help with a formula for concatenate and search/find with 3 columns	Mel	Excel Worksheet Functions	4	March 7th 05 09:12 PM

All times are GMT +1. The time now is 03:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us