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

**abhinavbinkar** · 08-19-2018, 10:18 AM

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

**BadlySpelledBuoy** · 08-19-2018, 10:50 AM

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

**abhinavbinkar** · 08-19-2018, 11:03 AM

Thank you so much.

**BadlySpelledBuoy** · 08-19-2018, 11:19 AM

Happy to help

BSB

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Convert a slash (/) date to a dot (.) date

[SOLVED] Prefill text box in userform with today's date but allow user to enter unique date

Format a row when user hits enter

Detect if user hits cancel from user input type box

[SOLVED] How? Link 2 cells from Sht 1 to 1 cell in Sht 2 separated w slash

Adding a date to calender to automatially generate another date?

[SOLVED] How do I enter a slash character in excel?

Bookmarks

Bookmarks

Posting Permissions