Did you try

=TEXT(B7+1,"00000000")

in B8 ?

--


Annoyed !!! Wrote:
That would be fine if I wasn't using a simple formula in the cells as
well.
It's a basic six digit date code with an extra two digits to determine
chronological order of production on batch number labels.

I've set it up so that it does a simple calculation =B7+1 for instance
where
B7 is the cell immediately above in the column so that it continues
down the
column when copied and pasted adding one number at a time. It needs to
be
flexible as some start with 0 if the day is 1 to 9 in the month. If I
could
only retain the custom number format instead of it changing to Greek
all the
time it would be fine.

"Bryan Hessey" wrote:


Set the cell formula to 'text' - ie:

=Text(A1*A2,"00000000")

or

=Text( your calculation ,"00000000")

--


Annoyed !!! Wrote:
If I want to use a number with 8 digits and a leading zero I've set
up
a
custom format using 8 zeros. Trouble is as soon as I go out of
format
option
the cell formatting changes to Greek. The leading zeros are
retained
but
dissapear when I use the info on the worksheet to merge to labels
or
other
Word documents.

How do I retain my custom cell formatting ????


--
Bryan Hessey

------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=540617




--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=540617