+ Reply to Thread
Results 1 to 3 of 3

Date problem using CONCATENATE

Hybrid View

Christopherdj Date problem using CONCATENATE 05-27-2020, 11:38 PM
Phuocam Re: Date problem using... 05-27-2020, 11:50 PM
Christopherdj Re: Date problem using... 05-28-2020, 12:03 AM
  1. #1
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Date problem using CONCATENATE

    Hi there, my file won't upload, the date is replicating as a number format from Cell $A2, is there any way to make it appear as typed without making the cell "Text".
    I'd like to use the Date elsewhere which is why I need it to remain as a date format (Cell A2)

    =CONCATENATE($A2," - ",$B2,$C2)
    Last edited by Christopherdj; 05-28-2020 at 12:03 AM.

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2024
    Posts
    6,175

    Re: Date problem using CONCATENATE

    Try this:

    =CONCATENATE(TEXT($A2,"dd/mm/yyyy")," - ",$B2,$C2)

  3. #3
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Re: Date problem using CONCATENATE

    Great outcome, works brilliantly. I thought it would be a simple fix, my mind was at DATE instead of TEXT.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] =CONCATENATE problem
    By Tarqish in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-24-2019, 04:37 AM
  2. [SOLVED] Concatenate Problem
    By dcningbo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-18-2014, 03:46 PM
  3. [SOLVED] Text with date concatenate problem
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-18-2013, 11:40 AM
  4. CONCATENATE & IF problem
    By dOOb in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-23-2013, 09:47 AM
  5. Concatenate Problem
    By keithr in forum Excel General
    Replies: 3
    Last Post: 03-29-2008, 02:00 PM
  6. Concatenate Problem
    By tshirttom in forum Excel General
    Replies: 7
    Last Post: 03-06-2008, 03:42 PM
  7. [SOLVED] [SOLVED] I know how to concatenate ,can one de-concatenate to split date?
    By QUICK BOOKS PROBLEM- in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-26-2005, 01:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1