I have a question.. In Notepad the number is 123456789898 and when I open this into excel 123456789800....it automatically removed last two original number which was "98" and added "00" at the end. how can be find out these issue can anyone help on this
Best video on the internet for this task.
Awesome 👍
This is what I'm talking about
A practical and easy solution in a short period of time
Well done 👍
Thanks! I'm glad you like that pace! I will try and do more in the "sweet-spot" like this, not too long or too short or too verbose.
Thank you! Solution number 2 was exactly what I needed.
If u noticed, this method changes all first/single digit to the number '0'. Not exactly the best way if u want to preserve the every single number
What do to with the numbers starting with zero?
Resolved my concern for assessment given for interview, Thanks a lot sir.. Keep posting more videos
Great tips. Thanks!!
Thanks Wayne! :)
Great Tips..Thank You Sir :)
You're very welcome Darryl!
I just tried all three methods and non of them worked. Any suggestions?
fantastic
But is still remains the same when you open it after saving.
I agree it remains the same once you save and try to open it again
best one
trim not work!!!
But in CSV file no more like that 😢
I have 25+ numbers, then how to convert same
Teşekkürler...
You're welcome!)
I have a question.. In Notepad the number is 123456789898 and when I open this into excel 123456789800....it automatically removed last two original number which was "98" and added "00" at the end. how can be find out these issue can anyone help on this
I just expanded the cell after using TRIM and that resolved the issue.
Try entering 20 digits without including zero. You won't get any numbers after 15 digits but zeros. This video is waste.