Results 1 to 3 of 3

Thread: Custom Cell Format To Display 8 Digit Numeric Value As Date In DD/MM/YYYY Format

  1. #1
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    12

    Custom Cell Format To Display 8 Digit Numeric Value As Date In DD/MM/YYYY Format

    I would like to know how to set a custom format so that if a user enters a date for eg as 28022014 , it will automatically format as 28/02/2014

  2. #2
    Junior Member
    Join Date
    Aug 2014
    Posts
    10
    Rep Power
    0
    As long as you don't need to actually use that as a date in any calculations.


    00\/00\/0000

  3. #3
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    12
    Thanks for the help, much appreciated

Similar Threads

  1. Replies: 5
    Last Post: 06-13-2014, 08:37 PM
  2. Replies: 4
    Last Post: 02-03-2014, 07:01 PM
  3. Replies: 3
    Last Post: 04-05-2013, 08:24 AM
  4. Replies: 4
    Last Post: 03-10-2012, 07:15 PM
  5. Convert Text In YYYYMMDD Format To Date Format
    By S M C in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 02-28-2012, 12:04 AM

Posting Permissions

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