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,

Private Sub Workbook_Open()
Columns("A:A").NumberFormat = "@"
End Sub

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.

Leading Zeros-Is this possible?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Leading Zeros-Is this possible?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions