each number in cell should be 10 digit

[Guest]

I am getting numbers in excel from a database..i want that each number should
be 10 digit and if less than ten digit then it should be preceded by 0
(zeros) to make it 10 digit number.

 

[Niek Otten]

To keep the numeric value but show 10 digits, Format Custom as 0000000000
To get a 10-character text string: =TEXT(A1,"0000000000")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am getting numbers in excel from a database..i want that each number should
| be 10 digit and if less than ten digit then it should be preceded by 0
| (zeros) to make it 10 digit number.

 

[Ron Rosenfeld]

I am getting numbers in excel from a database..i want that each number should
be 10 digit and if less than ten digit then it should be preceded by 0
(zeros) to make it 10 digit number.

Format the cells as:

Format/Cells/Number/Custom Type: 0000000000


--ron