MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?


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.