Excel Data / Number not recognised

Hi, I exported a csv file from an app and Excel is not recognising the cells data / numbers in several columns no matter what I do. I have tried all the obvious remedies: Formatting Copy / pas...

excel

Anonymous

Mar 06, 2017

Hi Karen,

if you have a newer Version of Excel (2013/2016) did you try PowerQuery for importing the CSV file? You have much more possibilities to transform data including date and time formats.

In Excel 2016, select from the menue New Query o fthe Data tab the entry From File and then CSV. After selecting the file, you'll get then a preview windows with some options and you can launch the Query Editor for refining you query.

In Excel 2013, you'll have to activate the PowerQuery COM Add-In before you can use it. The Add-In appears then in its own tab.

Best,

Mourad

Karen Draper

Copper Contributor

Mar 06, 2017

Hi,

Thanks for that.

I have figured it out myself to a certain degree ... have had no experience with PowerQuery as yet thanks for the suggestion, going off to have a look at it now!

Forum Discussion

Excel Data / Number not recognised

Resources