Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Putting a leading zero in a columnPosted 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 columnPosted 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.