Results 1 to 7 of 7

concatenate date with number

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    365 Apps for Enterprise
    Posts
    666

    concatenate date with number

    Hi, I need to create a .csv file with the following format:

    yyyy/mm/dd,number

    example:

    2014/01/15,765

    I've tried using the concatenate function but it returns the numerical value of the date, and I can't get it to insert a comma between the date and the number. Tried using the TEXT function too but haven't been successful.

    Any advice?
    Thanks much!
    Last edited by jrtaylor; 07-07-2017 at 08:02 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Concatenate a date field keeping the date format
    By rrcrossman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2016, 04:28 PM
  2. [SOLVED] Concatenate whole number
    By bmbalamurali in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-16-2014, 10:14 AM
  3. [SOLVED] COncatenate Number and ;
    By Dante_sparda in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-01-2012, 03:58 PM
  4. Concatenate - number zero
    By lynnmc26 in forum Excel General
    Replies: 3
    Last Post: 01-14-2011, 05:03 PM
  5. How to Concatenate with a text & number
    By Damon Longworth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 07:05 AM
  6. [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

Tags for this Thread

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