Excel

I need help to convert a birthday in one format to another w/o using the cell formating by using EXTEXT and DATEDIF.

example: 901101 -> 1990-11-01

  1. 👍 0
  2. 👎 0
  3. 👁 111
asked by Andrew
  1. I used to know how to do this in older versions of Excel, but can't figure it out in the newer version I have now. Sorry, but maybe somebody else does.

    1. 👍 0
    2. 👎 0
    posted by Reed
  2. That is ok. I will figure it out. I appreciate that you are honest with me and that you took time to answer.

    1. 👍 0
    2. 👎 0
    posted by Andrew
  3. I agree with Reed.

    The unfortunate thing is that, as Microsoft and other companies think they are improving things with each new version, they are really making everything more complex and difficult to use. The worst thing I've seen lately is "the ribbon" that MS has put on different Office programs. =(

Respond to this Question

First Name

Your Response

Similar Questions

  1. java/programming

    ask the user to enter his or her birthday in the MM/DD/YYYY format and output the number of days between the birthday and today. This gives the person's age in days.

    asked by maria on March 7, 2011
  2. Python Programming

    Given a time in the 12 hour format with the suffix, either AM/PM, convert that into a 24 hour format. 12 hour format is hours:minutes:seconds followed by AM or PM, where the hours range is from 0 to 12, minutes range is from 0 to

    asked by Rudra on September 1, 2016
  3. Math

    Matt got a dollar on his birthday. On his second birthday he will get the amount from last year's birthday plus as many dollars as he is old. How much would he receive on his birthday when 12 if this pattern is used. I came up

    asked by Kathy on April 5, 2018
  4. math

    Your great uncle gave you $2 on your first birthday, $4 on your 2nd birthday, $8 on your 3rd birthday, and so on. (a) How much money will you receive on your 18th birthday? (b) How much money will you receive on your nth birthday

    asked by alicia on December 14, 2009
  5. math

    Your great uncle gave you $2 on your first birthday, $4 on your 2nd birthday, $8 on your 3rd birthday, and so on. (a) How much money will you receive on your 18th birthday? (b) How much money will you receive on your nth birthday

    asked by Ella Mae on December 22, 2009
  6. math

    Chris received $1 on his first birthday,$3 on his second birthday,$6 on his third birthday,$10 on his four birthday.How much money will Chris receive on his eighth birthday if the pattern continues?

    asked by Kyara Vargas on May 9, 2011
  7. English

    What is the part of speech of "for my birthday" in each sentence? An adverb phrase or an adjective phrase? Would you check them, please? Can a phrase be either an adjective phrase or an adverbial phrase? Thank you. 1. What do I

    asked by rfvv on March 11, 2017
  8. history

    What is the best format to use when doing a birthday time line

    asked by alex on February 22, 2009
  9. English

    What did yo do on your last birthday? 1. My family celebrated my birthday with a birthday cake at home. 2. At the birthday party at home, my family celebrated me. 3. My family celebrated my birthday by singing a birthday song for

    asked by rfvv on August 14, 2018
  10. Today is my.......

    Today is my birthday! I wonder what is my HOROSCOPE SIGN? Is it Capricorn? HAPPY BIRTHDAY KAVERI!!!!!!!! WHEN I SAY HAPPY YOU SAY BIRTHDAY HAPPY BIRTHDAY HAPPY BIRTHDAY HAPPY BIRTHDAY TO YOU , HAPPY BIRTHDAY TO YOU , HAPPY

    asked by Kaveri on December 31, 2006

More Similar Questions