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.

Share This Page