I've exported a large amount of info from an accounts package, and one of the
cells for each line has a ten digit number, the majority of which start with
0(zero). When i open this spreadsheet to look at it all the zeros at the
beginning of these numbers disappear. How do I put them back, or stop excel
from doing this? I have tried formating the cell to text and using find and
replace, and I have tried copying the column into word, changing the numbers
and pasting back into excel, but it still loses the 0.