Leading Zeros-Is this possible?

**clarabelle** · 06-13-2007, 06:19 AM

Good Morning,

I am looking for a way to ensure that all the leading zeros in one column are present without having to format the column cell be cell. Is this possible?

Cheers

Claire

**sweep** · 06-13-2007, 07:01 AM

Hi,

Select the column you want to format with leading zeros, by clicking the column header.

Go to Format > Cells > Number Tab > Text

**clarabelle** · 06-13-2007, 07:12 AM

Hi,

Tried that, the problem is that the cells have already been populated but they don't seem to have been formatted, so by the time it reaches me I'm not sure if certain cells are supposed to have 1 or 2 leading zeros. Does that make sense?

Looking for a solution to this as we are receiving worksheets with thousands of assets each month.

Thanks

Claire

**sweep** · 06-13-2007, 07:20 AM

So when you get this data it doesn't have the leading zeros?

**clarabelle** · 06-13-2007, 07:23 AM

No, but it should have, it's being populated by different people and then passed to us, so I don't know if they're sheets have been formatted

**sweep** · 06-13-2007, 07:28 AM

If its the same workbook being populated every time, you could put this code in the workbook,

Please Login or Register  to view this content.

so it runs every time the workbook is opened, and formats the column to text. Then when it's populated it will always be formatted correctly.

**clarabelle** · 06-13-2007, 07:49 AM

Cheers Dave

, I'll try that.

Claire

**clarabelle** · 06-13-2007, 08:14 AM

Dave,

Sorry being a bit dim, how do I enter the code that you've suggested?

Claire

**VBA Noob** · 06-13-2007, 08:16 AM

See link

http://www.contextures.com/xlvba01.html#Workbook

VBA Noob

**clarabelle** · 06-13-2007, 09:12 AM

okay tried that, once you've pasted the code do you hit run or save, not very good at this type of thing

and all the advice given is very welcome.

**sweep** · 06-13-2007, 09:20 AM

Once you've pasted the code, close the VBA editor, then save the worksheet and close it. The next time you open the sheet the code will run.

Dave

**clarabelle** · 06-13-2007, 10:43 AM

Yeah, it worked!

Cheers everyone

**sweep** · 06-13-2007, 10:49 AM

Your welcome!

Leading Zeros-Is this possible?

LinkBack

Thread Tools

Rate This Thread

Display

Leading Zeros-Is this possible?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions