Forum Discussion
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...
Hello Karen
Could you provide us with the CSV file?
Hi,
Thanks for responding.
It is .out file not csv as I orginally posted. I couldn't open the file so copied and pasted the data (from the webpage) instead.
Discovered today that using the paste special "text" option solves it in the interim. Then when I couldn't open the file via Excel I dragged it into an open workbook / worksheet and this too solved my problem!
Hours I spent searching for solutions and got them in seconds today :-) Murphy's Law.
Would you have any advice using .out files?