Re: Excel number format problems

Giganews Newsgroups
Subject: Re: Excel number format problems
Posted by:  Bryan Hessey (
Date: Wed, 10 May 2006

Set the cell formula to 'text' - ie:



=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:
View this thread:


In response to

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