cyberchief Posted May 9, 2005 Report Share Posted May 9, 2005 In my macro, I am copying a 13 digit account number. I currently copy it into text format. I need to use the last 3 digits of the account number for a specific field. So, I ammend that to another variable, but I also need to modify it by incrementing it up by 1 number. So, I save it to an integer variable. My problem is that sometimes, those last 3 digits begin with a 0. I am forced to use the interger variable because I have to increment it up by 1. But when pasting the interger variable, it is dropping off the 0. Say the 3 digit is 023, I need to increment that up by 1 to 024 and I need the 0 to show. Am I doing something wrong? Is there a better way to do this? 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.