Converting a date to a text field w/o converting it to a julian da

Discussion in 'Microsoft Excel Worksheet Functions' started by LynnMinn, Mar 6, 2008.

  1. LynnMinn

    LynnMinn Guest

    In order to import data from an Excel spreadsheet into the software I operate
    at work all cells need to be formated as text. I recieve numerous
    spreadsheets with the date formated as a date XX/XX/XXXX and I need to
    convert it to text XXXXXXXX. How can this be done without converting the
    number to a julian date?
     
    LynnMinn, Mar 6, 2008
    #1
    1. Advertisements

  2. LynnMinn

    Fred Smith Guest

    Just use the Text function as is:

    =text(a1,"yyyymmdd")

    Regards,
    Fred.

    "LynnMinn" <> wrote in message
    news:...
    > In order to import data from an Excel spreadsheet into the software I
    > operate
    > at work all cells need to be formated as text. I recieve numerous
    > spreadsheets with the date formated as a date XX/XX/XXXX and I need to
    > convert it to text XXXXXXXX. How can this be done without converting the
    > number to a julian date?
     
    Fred Smith, Mar 6, 2008
    #2
    1. Advertisements

  3. LynnMinn

    Tyro Guest

    I'm confused. Are your dates Excel dates? Or are they text? And what would
    converting Gregorian dates to Julian dates accomplish?

    Tyro

    "LynnMinn" <> wrote in message
    news:...
    > In order to import data from an Excel spreadsheet into the software I
    > operate
    > at work all cells need to be formated as text. I recieve numerous
    > spreadsheets with the date formated as a date XX/XX/XXXX and I need to
    > convert it to text XXXXXXXX. How can this be done without converting the
    > number to a julian date?
     
    Tyro, Mar 6, 2008
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bob Umlas

    Re: Julian Date to Calendar Date

    Bob Umlas, Feb 26, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    1,812
    Bob Umlas
    Feb 26, 2004
  2. Guest

    how to convert julian date to regular calendar date

    Guest, May 5, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    356
  3. Guest

    converting julian day and year to a date?

    Guest, Feb 27, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    1,626
    fmanowhereman
    Aug 27, 2014
  4. Guest

    How do I convert a julian date to a regular date?

    Guest, Mar 14, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    288
    dpatte601
    Apr 17, 2006
  5. Guest

    how to convert julian date to general date

    Guest, Apr 3, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    175
    Guest
    Apr 3, 2006
Loading...

Share This Page