Addng numbers and leaving 0000 in front

G

gacollege

Is there a way I can add numerical values and leave the zero's ou
front?


EXAMPLE:

Cell A1 00002345
Cell A2 00002346 (based on the formula A1+1)

Thanks!
Richar
 
E

ElsiePOA

:cool:
If you select the cells and format them using the custom option, typin
in eight zeros, all of the numbers will be eight digits long with zero
in the front making up the difference between actual number and eight.


Example:
00002345
00002346
00012345
00123456

If, however, you want exactly four zeros in front regardless of th
number of digits in the calcualted number, I'm not sure how to do that
 
M

Myrna Larson

Hi, John:

If the underlying purpose is to make all of the entries the same length (as
opposed to having 4 leading zeroes), I think you should use all zeroes in the
format code, 00000000.

I tried your format on a cell containing the number 12, and it gave me 000012
rather than 00000012.
 
Top