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?
|