silentdud Posted July 20, 2008 Share Posted July 20, 2008 I write VBA and VBS but it takes me a long time to write anything substantial and I can read much better than I can write it haha. Basically my problem is this: I need to convert certain entire columns with thousands of entries to text in VBA because there is a bug in excel which converts all but certain random cells to text, requiring it to be done manually. They are in number format and I want to ensure that every cell in that column is a number. It is something that I do over and over again in the same columns for about a hundred times, so it might save me a ton of time... Can someone write the few lines of code I would need to do this? I understand the concept of what I need to do and the steps I just cant get code it to work right and I know its a simple task for a good programmer. =) Thanks Michael Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.