The problem data to a Word file

akram1400 We don't know what software and processing is involved in "transferring data to Word through correspondence".  Perhaps you could describe those.

Alternatively, perhaps you could fix the problem by changing the Excel worksheet, in one of two ways.  But let me mention that:

• You did not identify which columns those sample data are in.  My example will use column F for DATE H and column G for DATE M.
• You did not identify the "Locale (location)" for what I presume is your Hijri date formatting.  My example will use "Arabic (Saudi Arabia)".
• You did not identify how the DATE H column obtains its value.  Is it direct data entry (i.e., typing, or copying and pasting)?  Is it a formula that copies the DATE M cell for that row, but the cell formats it as a Hijri date?  Or is it loaded via some other technique?

So two possible solutions are to:

• add a column that stores a copy of DATE H as text, rather than as a date.  That formula -- for row 25, for example -- would be simply:

=TEXT(F25, "[$-,106]B2d/mm/yyyy;@")​

The concern with this technique is whether your existing software and processing could readily be changed to use the new column.

• store the DATE H column value itself as text rather than a date.  This could work, e.g., if the DATE H column contains a formula referring to the DATE M value.  In this case, the formula -- for row 25, again -- might be almost identical to the one shown above: 

=TEXT(G25, "[$-,106]B2d/mm/yyyy;@")

But other parts of your worksheet might rely on DATE H being a date value.