I needed an event macro to replace date format "DD.MM.YYYY" with "DD/MM/YYYY" as soon as user hits enter in Column J of my particular worksheet.
I needed an event macro to replace date format "DD.MM.YYYY" with "DD/MM/YYYY" as soon as user hits enter in Column J of my particular worksheet.
why macro ? you can simply select column J and Ctrl+H Replace . with /
or Data Validation to make sure it is entered correctly in the first place?
If user copy paste data from other sheet in "." format then I needs it to auto convert into "/" date format.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks