Forum Discussion
Solved
csv data type
Dear All, I downloaded a CSV file from a finance web site. I have downloaded their CSV files before and use them in Power Query, Excel and so on so I know they are usually fine. The first row...
I have see this happen sometimes when you try to convert it to a whole number and it wont let you. For me, it was because some of the fields really were NOT NUMBERS. Double check your data to make sure that:
1. There really are only numbers in the column
2. If your header repeats itself in the file, make sure you remove that header by filtering it out.
Hello,
be very careful with blank cells at your excel / csv file in your number columns. Make sure your blank cells are valued to '0'
Thank you