each number in cell should be 10 digit
 

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.

each number in cell should be 10 digit
 

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

"Vipul" wrote in message ...
|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.

each number in cell should be 10 digit
 

On Thu, 2 Nov 2006 03:01:02 -0800, Vipul
wrote:

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