Adding zeros to a number....

[excel_2009]

hi excel gurus,

Excel seems to have an issue with the data i'm trying to retrieve from my sql database, i have a column that consists of 13 digit numbers e.g 0000000000017 however in excel the zeros are disappearing, some of the numbers contain whole numbers e.g 9790900298577

is there any way of adding zeros in front of numbers that are less than 13 digits long?

Thank you

 

[Andrew Poulsom]

Format the cells as 0000000000000.

 

[excel_2009]

Format the cells as 0000000000000.

Thank you Andrew