View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bryan Hessey
 
Posts: n/a
Default Excel number format problems


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