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

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.
--
Gary's Student


"man" wrote:

> 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