[tdf-discuss] First LibO problem - OOo didn't do this...

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 discuss+help@documentfoundation.org
Archive: http://www.documentfoundation.org/lists/discuss/
*** All posts to this list are publicly archived for eternity ***