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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks