+ Reply to Thread
Results 1 to 4 of 4

Replace . with / in column as soon as hits enter

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

    Replace . with / in column as soon as hits enter

    I needed to replace . with / as soon as user hits enter everytime in Column J of my particular worksheet.

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Replace . with / in column as soon as hits enter

    Try this in sheet module.

    Please Login or Register  to view this content.
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

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

    Re: Replace . with / in column as soon as hits enter

    SOLVED. Thank you so much sir.

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

    Re: Replace . with / in column as soon as hits enter

    Sir,

    When I try to type "02.01.2019" in column J then it is converting as "01/02/2019" instead of "02/01/2019". Month is coming first instead of "DD/MM/YYYY" format. My PC's default date setting and Column J date setting are also in DD/MM/YYYY format. Can it get resolved?

    Please help sir.

    - Abhinav
    Last edited by abhinavbinkar; 01-15-2019 at 10:37 AM.

+ 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] Date separated by DOT to automatially convert into Slash as soon as user hits enter
    By abhinavbinkar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-19-2018, 11:19 AM
  2. Show When a Column Hits a Certain Number?
    By Procktopia in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-08-2018, 03:49 PM
  3. Formula for a reaction when another column hits a certain value.
    By BackRow in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-27-2017, 11:48 PM
  4. Sum a column until it hits a certain value then stop
    By truxhavenx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2015, 11:19 AM
  5. [SOLVED] repeating macro column by column until it hits a blank
    By bardobhb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-26-2014, 07:05 PM
  6. 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
  7. Search and highlight hits only in Column C
    By kenelder in forum Excel General
    Replies: 5
    Last Post: 06-12-2013, 11:44 AM

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