On Wed, 27 Dec 2006 12:41:01 -0800, Sean Timmons
wrote:

This has to be an easy one, but I can't find it. How do I retain the leading
zero in a number and retain number formatting?

Two ways typically:
- The most common is to format the cell as Text. (Format- Cells -
Text)
- Another less common one is to use the custom format 0########, where
you put as many hash signs as the maximum expected width of the entry.

(I have no idea what that is in Excel 2007's "ribbons" or whatever the
hell they are, nor do I much want to at this point.)

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *