Results 1 to 4 of 4

Thread: Converting Date field in Cell from DD-MMM-YY to YYYYMMDD

  1. #1

    Converting Date field in Cell from DD-MMM-YY to YYYYMMDD



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I've been trying to get this going with no luck so far, can anyone provide assistance please? Example is 25-Nov-13 needs to 20131113 for outbound EDI.

    Thanks for your support!
    -Chad

  2. #2
    Hello,

    =Text(--Target Cell--,"YYYYMMDD")

    Good luck,

  3. #3
    Thank you very much !!!!!! it worked great...been tickin me off most of the morning...owe ya one!

  4. #4
    Excellent. Glad to help. The text function is amazing. Microsoft has a very good page on it too if you want to google it.

    You're very welcome,

Posting Permissions

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