I needed to replace . with / as soon as user hits enter everytime in Column J of my particular worksheet.
I needed to replace . with / as soon as user hits enter everytime in Column J of my particular worksheet.
Try this in sheet module.
Please Login or Register to view this content.
Regards,
Thangavel D
Appreciate the help? CLICK *
SOLVED. Thank you so much sir.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks