Problem with column

[parscon]

I have a problem with data on column

i have a data like this 6/10 but when copy to excel it will convert to
10-Jun how can i fix it with VBA . this is only example 6/10 i need code for others like this in all cell of colunm A .

Thank you

[Bob Phillips]

Show us the code.

[parscon]

I added sample , when i write 6/10 covert to 10-Jun.

Thank you .

[Bob Phillips]

Just format the column as m/dd

[parscon]

could you please write me VBA code to do this ?

I need this for column F .

[harish1805]

you can convert it into a text string check this site may give you some ideas http://www.techonthenet.com/excel/formulas/text.php

[Bob Phillips]

ColumnS("F").NumberFormat = "m/dd"

[parscon]

Thank you for your help .