how to convert date format into string in EXCEL?

Question

I want to convert 14-Nov-06 to '14-Nov-06' so that I can make entery in my Oracle Table.

Answer 1

Try this formula:

=TEXT(XX,"mm-dd-yy"), where XX is the cell containing the date you want converted to text.

Answer 2

§His formula is right, but you need dd-mmm-yy if you want Nov written instead of 11.

Answer 3

by employing technique of 'string' do you mean convert it to a textual content representation of the month, i.E. 'Apr' or 'Jun'? if so, you ought to apply 'IF' or 'Case' statements. right that's a approach: Sub Conv_Month() Dim MyMonth, strMonth, newStr MyMonth = Month(Date) settle on on Case MyMonth Case Is = a million strMonth = "Jan" Case Is = 2 strMonth = "Feb" Case Is = 3 strMonth = "Mar" Case Is = 4 strMonth = "Apr" Case Is = 5 strMonth = "ought to" Case Is = 6 strMonth = "Jun" Case Is = 7 strMonth = "Jul" Case Is = 8 strMonth = "Aug" Case Is = 9 strMonth = "Sep" Case Is = 10 strMonth = "Oct" Case Is = 11 strMonth = "Nov" Case Is = 12 strMonth = "Dec" end %. If [E1].cost <> "" Then newStr = [E1].cost & " " & strMonth end If end Sub