I think this is what I want to do...
I'm using Office 2003.
What I'm trying to accomplish is this:
I have a column with a string of numbers and in some of the cells there is a leading zero missing, my list is extremely lengthy so adding this in manually or using a concatenate function is proving to be extremely time consuming and tedious.
I'm wondering if/how I can write a statement or formula to say "if the cell contains a string of 11 numbers, add a leading zero or a zero to the left of the string. if the string of numbers contains 12 numbers than leave as is." Can anyone tell me how I would do this?
Thanks,
Andrea

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic