Ticking the "Detect special number" box worked! Thank you! Thank you, Carol LTS Tools, Inc 40 Conway St South Deerfield, Ma 01373 413-775-3026 phone In a message dated 4/3/2018 12:54:28 AM Eastern Standard Time, mar...@groenescheij.com writes:
On 03/04/18 12:04 AM, LTS Tools, Inc wrote: > Hello, > > I am trying to download an excel spread sheet from ebay. Every time I do, the > column with prices has an apostrophe before the number so I cannot add up the > columns. My older version didn't do this. Please help! If you download a Excel file that the problem is with the Excel file. If you copy data into into an OpenOffice file or open a csv file into OpenOffice tick the 'Detect special number" box in the Import window. > > Thank you, > Carol > LTS Tools, Inc > 40 Conway St > South Deerfield, Ma 01373 > 413-775-3026 phone