Log Box upload

%3CLINGO-SUB%20id%3D%22lingo-sub-1853598%22%20slang%3D%22en-US%22%3ELog%20Box%20upload%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1853598%22%20slang%3D%22en-US%22%3E%3CP%3Ehow%20can%20you%20eliminate%20the%20'%20from%20the%20number%20on%20a%20downloaded%20spreadsheet%20from%20Logbox%20like%20this%3A%26nbsp%3B%26nbsp%3B'0.23%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20found%20an%20option%20on%20excel%20to%20convert%20to%20a%20number%2C%20but%20i%20have%20to%20do%20this%20individually%2C%20which%20is%20a%20pain%20when%20you%20have%2010%2C000%20rows!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1853598%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1853658%22%20slang%3D%22en-US%22%3ERe%3A%20Log%20Box%20upload%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1853658%22%20slang%3D%22en-US%22%3EOne%20simple%20way%3A%20Data%2C%20Text-to-columns%3C%2FLINGO-BODY%3E
Occasional Visitor

how can you eliminate the ' from the number on a downloaded spreadsheet from Logbox like this:  '0.23

 

i found an option on excel to convert to a number, but i have to do this individually, which is a pain when you have 10,000 rows!

1 Reply
One simple way: Data, Text-to-columns