Hi all,
I have a problem with LO Calc.
I have copied/pasted an other table, from web, that contains text and monetary data, in text form. Then I've replaced the currency form to appear only as an integer, finally to change to monetary form to classify them.
Example: Was: R$ 5.321,00 To: 5321
But when I set monetary form LO Calc puts a character ' on each start of number, to make it literal, but they don't be text!!! They're numbers!!!
What can I do to shoot out this conversion???
Tks a lot
Select the column
Click Data
Select Text to Columns...
Highlight the column and change the type from Text to Standard
You could also edit the cells one by one and remove the ' in front of the number
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-02-23 14:23:39 +0200
Seen: 269 times
Last updated: Feb 23 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Hi @Jeferson, did @drone27of1 answer your question? If so, please mark his answer as correct. Thanks!
qubit ( 2013-01-20 00:50:04 +0200 )edit