G Guest Apr 30, 2004 #1 I want to get a quick way to format a column in an Excel sheet (as date in "M/d/yyyy"). Any body has sample codes Thanks in advance
I want to get a quick way to format a column in an Excel sheet (as date in "M/d/yyyy"). Any body has sample codes Thanks in advance
W William Ryan eMVP Apr 30, 2004 #2 I don't have the code off the top of my head, but record a macro, change the formatting in a cell, stop the macro..it will give you the code you need. Li Pang said: I want to get a quick way to format a column in an Excel sheet (as date in Click to expand... "M/d/yyyy"). Any body has sample codes.
I don't have the code off the top of my head, but record a macro, change the formatting in a cell, stop the macro..it will give you the code you need. Li Pang said: I want to get a quick way to format a column in an Excel sheet (as date in Click to expand... "M/d/yyyy"). Any body has sample codes.
