title: Change text to specific date format + Excel VBA
body: <p>I want to change so many dates saved as text in excel sheets to Arabic (Hijri) date format, ie; dd/mm/yyyy to  (right to left) yyyy/mm/dd .. it can be done manually be change custom format from Number Format panel ( by choosing the location , calendar type and the right format from list ) then replace the text in cell by same value ..<br>
  I need VBA code to automate this replacement process for any ltr date and for existing rtl date just convert the format from general to date ..   </p>
  
  <p>another problem , there is some other text around the date in cell like ( dd/mm/yyyy ttt ) . I want the code to remove this text (ttt) ( any text ) and then change to the right format</p>
  
  <p>I found this code but it is not work to my specific need<br>
  <a href="https://stackoverflow.com/questions/7106238/changing-the-date-format-to-yyyy-mm-dd">Changing the date format to yyyy-mm-dd</a>    </p>
  
  <p>I appreciate any help , thanks in advance ..</p>