SonicBoomAu Posted April 20, 2005 Posted April 20, 2005 Hi All, I am trying to change a column in a Excel Spreedsheet from Text to Short Date. Is this possible??? If not a column what about a range M3 to M30? SonicBoomAu Quote Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. -- Rick Cook, The Wizardry Compiled
SonicBoomAu Posted April 20, 2005 Author Posted April 20, 2005 Have found an answer: objSheet.Range("M3", "M999").NumberFormat = "dd-MMM-yyyy" My question now is there a better way of doing this???? Quote Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. -- Rick Cook, The Wizardry Compiled
Recommended Posts