+ Reply to Thread
Results 1 to 3 of 3

Military time format not sticking when I concantenate

  1. #1
    Registered User
    Join Date
    05-18-2012
    Location
    Chicago
    MS-Off Ver
    Excel for Mac 2011
    Posts
    2

    Military time format not sticking when I concantenate

    I am not a high level excel user and am really struggling with making my military time , let's say-- 1342, continue to read as 1342 when I concatenate it with other fields. It keeps converting it to a decimal within the concatenated line. I tried just copying and pasting/special- values the column of military time to make it statically military in appearance before I concatenate, but it's not working. What in the world am I doing wrong?
    I'd just retype it as text, except I have thousands of lines to concatenate.
    Please help a novice.

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Military time format not sticking when I concantenate

    Try using TEXT function in your concatenation formula, for example if you have a time in A1 use a formula like

    ="Arrival time is "&TEXT(A1,"hhmm")
    Audere est facere

  3. #3
    Registered User
    Join Date
    05-18-2012
    Location
    Chicago
    MS-Off Ver
    Excel for Mac 2011
    Posts
    2

    Re: Military time format not sticking when I concantenate

    Thank you! I could just copy my column with =TEXT(A1,"hhmm") then! ----then copy/paste special-values before I begin the concatenation process too. Thank you so much for your help- this works.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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