+ Reply to Thread
Results 1 to 2 of 2

CONCATENATE 1

  1. 03-09-2005, 06:06 PM #1
    AYPCN
    Guest

    CONCATENATE 1

    J5
    HFUP,

    K5
    031005

    L5
    =CONCATENATE(J5,K5)
    HFUP,38421 how can i get this date corrected to show what is in K5 tryed
    formating cell to mmddyy

    thanx


    Reply With QuoteRegister To Reply
  2. 03-09-2005, 08:06 PM #2
    Gap
    Guest

    Re: CONCATENATE 1

    =CONCATENATE(J5,MONTH(K5),"/",DAY(K5),"/",YEAR(K5))

    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1