Changing Cell Value format as desired while saving the file in the current directory

Originally Posted by Ravisca2003

https://powerspreadsheets.com/vba-fo...ing-VBA-mmm-yy

refer this for guidance. You may either while selecting the range, chnge the format of date internally.

Please supply your answer and not a link to the possible answer.