Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Manage funky number formats importing csv file

Hi community,   i'm getting strange number formats like "10. Apr" when importing csv file. the number should be "10.04" and it works for some numbers in the same column like 28.05 or 12.00. I trie...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Pete, 

thanks for your reply.

i already deleted the data type detection und have manually routine to manage necessery data types. To set the options globally didn't work. Do you know any other options applied when opening csv in excel? the wrong formats appears already when opening csv in excel. Only in text (Notepad) i get the right data.

 

Thanks

Ksenia

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
4 years ago

Hi Anonymous ,

 

When you first import the CSV using Get Data, you actually specify the detection at that point. You should set the following option to 'Do not detect data types':

 

Pete