Thanks, I only know the first method, but I am in search of bulk copying the data from one sheet into another without changing the scientific notation and this is the most effective and simple video demonstrating how to do the same. Thanks 🎉🎉
@@ChesterTugwell I followed your way but last digit is still 0. I have a column with 16 numbers. Changed decimal to text. Replace current>load and close, but no changes
Thanks sir...but my pc win10. I have Ms office 12.....excel option...but in option no data tab is there......would you suggest then how can I select text legacy...
If anyone can help with this. It works for me when i add the add the apostrophe. But when i preformat the cells to text it still puts the numbers in as scientific values. If anyone can help with this that would be great. Edit. Never mind. Figured it out. apparently whatever i was copying from was changing the format back to general instead of text. When i copied the data from another location it worked okay.
I'm working with 13 digit barcodes. Nothing longer than 13 digits. Excel changed them all so that now they have 14 digits, the last 9 of which are all zero...
Yes I was just wondering if somewhere someone has just lost a whole bunch of important date because of this. I used to work as an import clerk and I was lucky this didn't chew up my serial numbers to be honest.
Bless you sir. I was on the verge of tears. Nothing was working until I got here!!
If formatted as text it gives you that weird decimal + abbreviation. How are you getting it to show you just the number?
Thanks for the clear explanation on how to fix an issue that's been bugging me for years!
Thanks Chester!
Thanks, I only know the first method, but I am in search of bulk copying the data from one sheet into another without changing the scientific notation and this is the most effective and simple video demonstrating how to do the same. Thanks 🎉🎉
Thank you. This was a big help. Couldn't find the answer anywhere else.
Many thanks
Thanks..it was the newer import process i was unfamiliar with..they dont make it obvious!
Thank you sir😊
Thank you kindly!
Thanks a lot Chester , you made my life easy and your new subscriber🙂
Welcome to the channel
@@ChesterTugwell I followed your way but last digit is still 0. I have a column with 16 numbers. Changed decimal to text. Replace current>load and close, but no changes
Thank you
Thanks
THANK SIR FOR UR VIDEO
Thanks sir...but my pc win10. I have Ms office 12.....excel option...but in option no data tab is there......would you suggest then how can I select text legacy...
Thanks, how to sort. String sorting numbers won’t work right?
can you use the duplicate in conditional formatting if the numbers are on text format?
Why dont Microsoft fix this??
Hi Chester, my excell does not have the Data in Options. I am using 2016
How to reverse the number already turned to zeros.
If anyone can help with this. It works for me when i add the add the apostrophe. But when i preformat the cells to text it still puts the numbers in as scientific values. If anyone can help with this that would be great.
Edit. Never mind. Figured it out. apparently whatever i was copying from was changing the format back to general instead of text. When i copied the data from another location it worked okay.
I'm working with 13 digit barcodes. Nothing longer than 13 digits. Excel changed them all so that now they have 14 digits, the last 9 of which are all zero...
Yes I was just wondering if somewhere someone has just lost a whole bunch of important date because of this. I used to work as an import clerk and I was lucky this didn't chew up my serial numbers to be honest.