So you want to keep the leading 0's? Then: n = 01234+ 50-100 /* Whatever calc */ n = right(n,5,0)
you'll have to put back the leading 0's after performing a calculation on it... adjust the '5' in the right() function to be the length you're looking for. Scott Rohling On Wed, Oct 15, 2008 at 8:51 AM, Howard Rifkind <[EMAIL PROTECTED]>wrote: > Greetings. > > Is there anyway to perform an arithmetic operation (add/subtract) on > a string of numbers that has a leading '0' (zero) and perceive the leading > zero? > > If I have the following: > > X = 01234 > > and I add/subtract some number from the above the leading zero is gone. > > Thanks > > > > _____________ > LEGAL NOTICE > Unless expressly stated otherwise, this message is confidential > and may be privileged. It is intended for the addressee(s) only. > Access to this E-mail by anyone else is unauthorized. > If you are not an addressee, any disclosure or copying of the > contents of this E-mail or any action taken (or not taken) in > reliance on it is unauthorized and may be unlawful. If you are not an > addressee, please inform the sender immediately, then delete this > message and empty from your trash. >
