Excel date format convert to string format

M

man

I have this problem
I would like to change a column format from (m.d.yyyy <== date format) to
(m.d.yyyy <== string format)

Any method I can use ?

thanks in advance
 
G

Gary''s Student

Enter this macro:

Sub gsnu()
Dim s As String
For Each r In Selection
s = r.Value
r.Clear
r.NumberFormat = "@"
r.Value = s
Next
End Sub

Then select the cells to be converted and run the macro.
 
Top