Re: Excel number format problems

Giganews Newsgroups
Subject: Re: Excel number format problems
Posted by:  Bryan Hessey (Bryan.Hessey.27laka_1147260900.7593@excelforum-nospam.com)
Date: Wed, 10 May 2006

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?action=getinfo&userid=21059
View this thread:http://www.excelforum.com/showthread.php?threadid=540617

Replies

In response to

Excel number format problems posted by Annoyed !!! on Wed, 10 May 2006