2:42 how to convert into * if original number not in same number of digits i mean few numbers 10 digits few of 8 or 9 but I want to show last digits number other digits i want to hide
Pad the number. Imagine your data is in A2. Follow this formula. =Text(A2,"0000000") . This will get you the result as follows: 1. 0000123 2.0012345 3.1234567. Within the formula I have given 7 times 0 because the highest number in the worksheet is 7 (1234567). Find out the highest number and accordingly place those digits in the text formula. Hope this would have solved your query 😀
Good day, I'm Akamstech i really need a help from you, i have a Data in excel, which is mask but i can't un_mask it or set it back again. the data is just like this ( 05423** **) i want to restore the missing number back, please sir can you help out, my work and life depend on it.
Wow.. Great video. You made the concept simple yet in an interesting way
Thanks for the feedback
Thank you very much madem I have been searching for this trick from three days. Thank you thank you very much madem
I'm go so glad to know that i helped you in some way Purna Chandra . Keep Watching,keep Learning
OMG you saved me so much time and effort. Thank you so much!!!!!!!
Great Video. Crisp and to the point
Appreciate it! Mahaveer
Great tutorial. Thanks for sharing
Awesome presentation and techniques, u deserve more subscribers
very good. If you do videos short (like this one )it is easy to grasp.
I love it! Thank you. I thought I have to do every cell manually
Thank you for make this video madam
It is my pleasure sree kanth sir. Keep Watching,Keep Learning
Nice use of Repeat function
Thanks Tony Hallett 👍
Quite helpful. ❤
Can u please upload of vice versa vedio to unhide number
As such there is no method to unhide the masked number
can i sum this hidden number ? although its not showing
Hi Hasan, Hidden number is considered as a text. So, you won't be able to add up the text
2:42 how to convert into * if original number not in same number of digits i mean few numbers 10 digits few of 8 or 9 but I want to show last digits number other digits i want to hide
Hi Sameer, Please follow this link for the same.
th-cam.com/video/Q2Rz4VW4mz0/w-d-xo.html
Hope this Helps :-)
@@karpagamexcelprime thanks
Boss, You can see the video, its may help you.
th-cam.com/video/d7mDmEcLgJc/w-d-xo.html
What if I have different number format in one column ?
For eg
123
12345
1234567
And so on
Pad the number. Imagine your data is in A2. Follow this formula. =Text(A2,"0000000") . This will get you the result as follows:
1. 0000123
2.0012345
3.1234567.
Within the formula I have given 7 times 0 because the highest number in the worksheet is 7 (1234567). Find out the highest number and accordingly place those digits in the text formula.
Hope this would have solved your query 😀
Thanks a lot for replying!!!
How to saw mask numbers
There are no ways to unmask the numbers at present Ramraj
How fo u unmask the ********
How do you unmask *****
how to unmask ?
Hi, Once a number is masked , you can't unmask it
@@karpagamexcelprime wtf?
Good day, I'm Akamstech i really need a help from you, i have a Data in excel, which is mask but i can't un_mask it or set it back again. the data is just like this ( 05423** **) i want to restore the missing number back, please sir can you help out, my work and life depend on it.
i am having the same problem. did you find the solution @akamstech?? if yes help me out as well.
please help me if you find a solution