problem with string begininng with 0

  • Thread starter Thread starter Tonso
  • Start date Start date
T

Tonso

Using xl2002, how can i start with a number string that begins in a 0,
and add a number to it. example, the string 08902002. how can i have
that number in a cell, and make another cell add 1 to it so it becomes
08902003. or add 3000 to it so it becomes 08905002, or whatever. when
i add 1, it drops the leading 0. In most instances, the string begins
with a non-zero number, but sometimes it begins in 0, or even 00.

Thanks,
Tonso
 
Try a custom format of:

00000000

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Using xl2002, how can i start with a number string that begins in a 0,
and add a number to it. example, the string 08902002. how can i have
that number in a cell, and make another cell add 1 to it so it becomes
08902003. or add 3000 to it so it becomes 08905002, or whatever. when
i add 1, it drops the leading 0. In most instances, the string begins
with a non-zero number, but sometimes it begins in 0, or even 00.

Thanks,
Tonso
 
I would use Ragdyer's suggestion of a custom format.

But if you want text:
=TEXT(A1+1,"00000000")
 
I would use Ragdyer's suggestion of a custom format.

But if you want text:
=TEXT(A1+1,"00000000")
Click to expand...

The custom format was just what I needed. Thanks to you both for
responding!
Tonso
 
We appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
I would use Ragdyer's suggestion of a custom format.

But if you want text:
=TEXT(A1+1,"00000000")
Click to expand...

The custom format was just what I needed. Thanks to you both for
responding!
Tonso
 
Back
Top