On 2010-11-23 4:36 PM, Charles Marcus wrote: > Ok, first real issue I've had with LibO... > > I have an old phone system that generates reports in CVS format. > > OOo always opened these with the number columns formatted as - numbers. > > LibO is formatting *some* of them as text fields, and when I change them > to numbers with no decimals (to remove the .00 it is adding to them that > OOo also never did), it adds the stupid ' character to the beginning of > every cell, thus making it impossible to format these as numbers. > > How can I easily remove the ' symbol from the beginning of every field?
Never mind - played with the 'Other options' when importing the CSV, unchecking 'Quoted field as text' and checking 'Detect special numbers' fixed the import up... -- Best regards, Charles -- Unsubscribe instructions: E-mail to [email protected] Archive: http://www.documentfoundation.org/lists/discuss/ *** All posts to this list are publicly archived for eternity ***
