Excel is automatically reformatting cells from text to date. I have cells that I want as text that are "Oct-97", "Nov-97", etc. I want the retained as text so I can load the excel sheet into Pagemaker. As dates, the text is too large for my cells causing the "###" to be in the cell. As text, there is no problem.
I am using VBA to read "Oct-97" from one worksheet and placing it into another worksheet as text. Excel automatically converts the format from text to Custom "mmm-yy". I do not want this.
So how can I stop excell from changing my cell formats?
I am using VBA to read "Oct-97" from one worksheet and placing it into another worksheet as text. Excel automatically converts the format from text to Custom "mmm-yy". I do not want this.
So how can I stop excell from changing my cell formats?