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