You all prolly dont care but does any of you know a method to get back into an Instagram account..? I somehow lost my password. I appreciate any tricks you can offer me
@Junior Jake Thanks for your reply. I found the site on google and im trying it out atm. Seems to take quite some time so I will get back to you later when my account password hopefully is recovered.
:( Same answer. I need to maintain zero pad on Export TO CSV. I'm about ready to use PHP or something with a decent file reading library just to read row by row and write a CSV FROM an Excel with left zero padding. Kinda unreal to me that the export doesn't allow for something similar on the way out, "Do NOT truncate my values, as seen, when exporting to CSV."
How do I you numbers longer that 12 digits in .CSV files without showing scientific notation please? A Medicare co. has to receive out number in .CSV format. I have searched for days. No luck. Every time i reopen the .csv file it goes back to scientific notation. I have tried everything. Columns only show 8 digits. My numbers are 10 digits. Thank you all.
Hi sorry for the late reply. It sounds like you missed a step - start the video at 3:10 and make sure you change the data format to text. You'll have to repeat these steps every time you open the file as Excel will always try to format the fields.
Hi you can add anything you want in Excel. If you add to another (blank) column and save the csv, you will see another comma has been added before your new data in each row.
The process has changed since I made this video and I'm not certain about 2016. Try this: Go to Data > Get & Transform Data > From File > From Text/CSV In the preview window top right click the Data Typ Detection dropdown and select "Do not detect data types" then click Transform Data at the bottom You should see all columns coming in as text and you can change the data type for each column using the Transform section of the ribbon Hope this helps!
it worked except that i need to upload it to my database using csv hence after doing all that i still need to save as csv. hence all de hardwork dissapeared😭
I can't help but feel Excel should open CSVs this way by default. The number of times I've received a list of account numbers in where half the values have been turned into scientific notation and the international dates have the Day mixed up with the Month makes wonder how much time is wasted globally due to bad software design.
Thanks for the video! It's 2021 and MS still hasn't implemented a simple option to turn off the annoying conversion in general.
You all prolly dont care but does any of you know a method to get back into an Instagram account..?
I somehow lost my password. I appreciate any tricks you can offer me
@Lachlan Vincenzo instablaster ;)
@Junior Jake Thanks for your reply. I found the site on google and im trying it out atm.
Seems to take quite some time so I will get back to you later when my account password hopefully is recovered.
Thank you for this tutorial. been looking for this since 2 years ago.
Thanks for putting this video up. Much appreciate it
THANK YOU HAVE BEEN LOOKING FOR HOURS but this do !!!
great hint! Thank you very much
:( Same answer. I need to maintain zero pad on Export TO CSV. I'm about ready to use PHP or something with a decent file reading library just to read row by row and write a CSV FROM an Excel with left zero padding. Kinda unreal to me that the export doesn't allow for something similar on the way out, "Do NOT truncate my values, as seen, when exporting to CSV."
thanks alot dear. that is so helpful. excel has a lot of hidden features, Indeed!
My goodness. This is amazing. Thank you so much. God Bless
Thanks a lot. This is really very helpful.
Not sure if I'm doing something wrong, followed step by step. But my new file displays phone number as 4.47225E+11?
Damn! This fixed my issue. Thank u!!
Thank you so much
How do I you numbers longer that 12 digits in .CSV files without showing scientific notation please?
A Medicare co. has to receive out number in .CSV format.
I have searched for days. No luck. Every time i reopen the .csv file it goes back to scientific notation.
I have tried everything. Columns only show 8 digits. My numbers are 10 digits. Thank you all.
Hi sorry for the late reply. It sounds like you missed a step - start the video at 3:10 and make sure you change the data format to text. You'll have to repeat these steps every time you open the file as Excel will always try to format the fields.
Thank you sooo much this helped me
you are a star!
Hi, Nice one but what about if we want to add price after importing it into excel
Hi you can add anything you want in Excel. If you add to another (blank) column and save the csv, you will see another comma has been added before your new data in each row.
Hi! Thank you very much for your tutorial! Do you know how to do it with Numbers (iWork)? Merry Christmas!!
Thanks, Camila
Hi Camila
Sorry I don't have any experience with iWork Numbers
Hi Dave! Thank you very much anyways. All the best!
Sir when we are mailing still it is in excrl format
Thank you so much!!
Very helpful
It does not work on office 2016, what can I do ?
The process has changed since I made this video and I'm not certain about 2016. Try this:
Go to Data > Get & Transform Data > From File > From Text/CSV
In the preview window top right click the Data Typ Detection dropdown and select "Do not detect data types" then click Transform Data at the bottom
You should see all columns coming in as text and you can change the data type for each column using the Transform section of the ribbon
Hope this helps!
it worked except that i need to upload it to my database using csv hence after doing all that i still need to save as csv. hence all de hardwork dissapeared😭
Hi if you save as CSV you won't lose anything. After you save you can check it by opening it in Notepad.
@@DaveHoder I am facing the same issue. Unable to upload the csv. file due to incorrect formatting.
Thank u
This doesn't work on 2010.
no it does not. Shoot!
thanks
I can't help but feel Excel should open CSVs this way by default. The number of times I've received a list of account numbers in where half the values have been turned into scientific notation and the international dates have the Day mixed up with the Month makes wonder how much time is wasted globally due to bad software design.
Yes, it's a well-known file format. And MS still hasn't implemented a simpler solution to turn off the annoying number conversion.