+ Reply to Thread
Results 1 to 4 of 4

Date separated by DOT to automatially convert into Slash as soon as user hits enter

  1. #1
    Forum Contributor
    Join Date
    07-09-2013
    Location
    Nagpur, India
    MS-Off Ver
    Excel 2010
    Posts
    256

    Date separated by DOT to automatially convert into Slash as soon as user hits enter

    Hello,

    If user enters the date separated by "." (dot). It should Automatically convert into "/" (Slash) as soon as user hits enter. Is it possible?

    - Abhinav
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,808

    Re: Date separated by DOT to automatially convet into Slash as soon as user hits enter

    You could try this in the worksheet module:
    Please Login or Register  to view this content.
    Change the bit in red to cover the range you want the date change to take place in.

    BSB

  3. #3
    Forum Contributor
    Join Date
    07-09-2013
    Location
    Nagpur, India
    MS-Off Ver
    Excel 2010
    Posts
    256

    Re: Date separated by DOT to automatially convet into Slash as soon as user hits enter

    Thank you so much.

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,808

    Re: Date separated by DOT to automatially convert into Slash as soon as user hits enter

    Happy to help

    BSB

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Convert a slash (/) date to a dot (.) date
    By antony moseley in forum Excel General
    Replies: 7
    Last Post: 11-23-2017, 11:19 AM
  2. [SOLVED] Prefill text box in userform with today's date but allow user to enter unique date
    By moosetales in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-02-2014, 09:17 AM
  3. Format a row when user hits enter
    By jcmckeon in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-29-2014, 01:42 PM
  4. Detect if user hits cancel from user input type box
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-20-2011, 11:42 AM
  5. How? Link 2 cells from Sht 1 to 1 cell in Sht 2 separated w slash
    By Peri in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-04-2006, 08:25 AM
  6. [SOLVED] Adding a date to calender to automatially generate another date?
    By Crystal Long in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-03-2006, 06:25 PM
  7. How do I enter a slash character in excel?
    By michaelgreen in forum Excel General
    Replies: 1
    Last Post: 06-13-2005, 10:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1