Hi! Catalin

I have attached the files.

In that Field AD of file named 'Typed version' Its manually typed as : Nov-09 and the formula bar also displays the same(Nov-09). Its formatted as Text.

In that Field AD of file named 'Converted version' Its posted from MS word(copy paste): November 03, 2009 and formatted as Mmm/yy and the formula bar displays as 11/3/2009. Its formatted as Text.

What i need is the AD field of file 'converted version' to display the same i.e. Jan-09 (Mmm-09). and the formula bar should also display the same. (Its not possible to re-write its since they are tooo large in numbers)but I dont mind what the formatting is. sothat when i take both these files to Comparison Software Both fields will be the same and it will return No Error.

I have attached a comparison file result were the dates are same but it shows error just because both are in diff format.

Please refer to the AD field of Comparison file.

Please provide me with a good remedy.....

Attached Files

Compare1.zip (34.8 KB, 10 views)