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? Redacted sample file attached. -- 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 ***
