PDA

View Full Version : Solved: problem with column



parscon
02-16-2012, 03:47 PM
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
02-16-2012, 03:52 PM
Show us the code.

parscon
02-16-2012, 03:55 PM
I added sample , when i write 6/10 covert to 10-Jun.

Thank you .

Bob Phillips
02-16-2012, 04:14 PM
Just format the column as m/dd

parscon
02-16-2012, 04:17 PM
could you please write me VBA code to do this ?

I need this for column F .

harish1805
02-16-2012, 11:17 PM
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
02-17-2012, 02:53 AM
ColmnS("F").NumberFormat = "m/dd"

parscon
02-17-2012, 08:57 AM
Thank you for your help .