I'm running Excel 2010 using a output file from our database software that exports a list of our affiliate stores. The affiliate stores have a 9 digit code and a number of these codes start with "0".

When this column is converted from text to numbers, Excel removes the initial digit if it starts with "0" and the result is that the 9 digit number becomes an 8 digit number. Is there a way to prepend a "0" to a number in a cell?

The ultimate goal is to run a script on these codes as the first 4 digits represent the region where the affiliate store is.