Funcky Date Conversion to "Text"
Results 1 to 3 of 3

Thread: Funcky Date Conversion to "Text"

  1. #1
    Board Regular gheyman's Avatar
    Join Date
    Nov 2005
    Location
    Orlando, FL USA
    Posts
    1,591
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Funcky Date Conversion to "Text"

    I have an excel import template for a software program the company I work for uses. The Software import template uses an unusual date format

    01/25/2018 would be 118
    10/01/2017 would be 1017

    I am trying to pull data from one of my spreadsheets to past into their template, but my spreadsheet uses the standard date formats. So I need to convert my dates to their format.

    I cant seem to come up with a formula to convert my date fields into their format. my spreadsheet is using m/dd/yyyy

    Their field on their excel import template is a "General" field.

    anyone have a suggestion other than changing my spreadsheet date format. If I asked my users to start entering dates that the software uses, I would laughed at (LOL).
    G Heyman
    Northrop Grumman - Laser Systems'
    Apopka, FL

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,456
    Post Thanks / Like
    Mentioned
    54 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Funcky Date Conversion to "Text"

    Assuming that you just want month and year.
    Formatting the cell would look like: myy
    To use a formula to convert the value would be: =TEXT(A1,"myy")
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    Board Regular gheyman's Avatar
    Join Date
    Nov 2005
    Location
    Orlando, FL USA
    Posts
    1,591
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Funcky Date Conversion to "Text"

    Thanks!
    G Heyman
    Northrop Grumman - Laser Systems'
    Apopka, FL

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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