exact length of the cell
 

I need to add a leading 0 if the length of the text is less than 10 char
Example: I have in A1 34126 so I need to 5 leading 0s in front
or
96750004 -so I need to add 2 leading 0s in front
What is the way to do it?

exact length of the cell
 

Use a custom number format of: 0000000000

FormatCellsNumber tabCustom
Below "Type:" enter 10 zeros
OK

--
Biff
Microsoft Excel MVP


"sabi0398" wrote in message
...
I need to add a leading 0 if the length of the text is less than 10 char
Example: I have in A1 34126 so I need to 5 leading 0s in front
or
96750004 -so I need to add 2 leading 0s in front
What is the way to do it?

exact length of the cell
 

Format Cells... Custom 0000000000
--
Gary''s Student - gsnu200808

exact length of the cell
 

sabi,

Note that formatting the cells will not change the actual length of the string, just how it is
displayed.

Use = TEXT(A1,"0000000000")

if you need the actual length to be 10 - copy the formula and paste down to match your data. You
can also copy those formula and paste values over the original data if that is required.

HTH,
Bernie
MS Excel MVP


"sabi0398" wrote in message
...
I need to add a leading 0 if the length of the text is less than 10 char
Example: I have in A1 34126 so I need to 5 leading 0s in front
or
96750004 -so I need to add 2 leading 0s in front
What is the way to do it?

exact length of the cell
 

in B1 put this formula

=LEFT(A1*1&TEXT(R19,"0000000000"),10)


On Oct 17, 9:56*pm, sabi0398
wrote:
I need to add a leading 0 if the length of the text is less than 10 char
Example: *I have in A1 34126 so I need to 5 leading 0s in front
or
96750004 -so I need to add 2 leading 0s in front
What is the way to do it?

exact length of the cell
 

sorry

=Text(A1,"0000000000")


On Oct 17, 10:17*pm, muddan madhu wrote:
in B1 put this formula

=LEFT(A1*1&TEXT(R19,"0000000000"),10)

On Oct 17, 9:56*pm, sabi0398
wrote:

I need to add a leading 0 if the length of the text is less than 10 char
Example: *I have in A1 34126 so I need to 5 leading 0s in front
or
96750004 -so I need to add 2 leading 0s in front
What is the way to do it?