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?