Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

Putting a leading zero in a column

Posted by Jim Byrne on August 15, 2001 8:43 AM

I need to put a zero in front of series of a 7 digit number. Any help?

Re: Putting a leading zero in a column

Posted by Mark W. on August 15, 2001 8:49 AM

If your value is truly numeric you can display a
leading 0 by using a custom format of 00000000

...otherwise you'll need to create a text
representation of your value in a separate column
using =TEXT(ref,"00000000") where "ref" is a cell
reference to one of your values.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.