If column C has only 4 numbers then enter a 0 at the beginning

[djfscouse]

Hi,

If column C has only 4 number in it then I would like to enter a 0 at the beginning and that the column is set as text format.

Example before vba applied using excel 2003

ColumnC
4565
12358
456541234
6657
65881

Example after vba applied

ColumnC
04565
12358
456541234
06657
65881

Thanks for any help,

David

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[djfscouse]

I found the one below which was posted by abousetta

Please Login or Register  to view this content.

[nilem]

or

Please Login or Register  to view this content.