LinkBack URL
About LinkBacks
Hello ilgnite,
Try these,
Enter your first no: in A1
A2, use
="*"&TEXT(SUBSTITUTE(A1,"*",""),"0")&"*"
A3, copy down.
="*"&TEXT(SUBSTITUTE(A2,"*","")+1,"0")&"*"
Hello ilgnite,
Try these,
Enter your first no: in A1
A2, use
="*"&TEXT(SUBSTITUTE(A1,"*",""),"0")&"*"
A3, copy down.
="*"&TEXT(SUBSTITUTE(A2,"*","")+1,"0")&"*"
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks