Thread
:
exact length of the cell
View Single Post
#
1
Posted to microsoft.public.excel.misc
sabi0398
external usenet poster
Posts: 1
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?
Reply With Quote
sabi0398
View Public Profile
Find all posts by sabi0398