I have a column in my spreadsheet with a number that is 7 characters long. I
want to creat a custom format for these cells to make them 10 characters long
and so I created a custom setting with 0000000000 and that usually works. It
normally places the extra 3 zeros in front of the 7 characters but on this
spreadsheet it only does it to one of the cells in that row. As far as I can
tell, there is nothing different about that cell. Any ideas?

Thanks!