Ask Your Question

Calc problem when change data type [closed]

asked 2012-02-23 14:23:39 +0200

Jeferson gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-15 05:10:46.833852


Hi @Jeferson, did @drone27of1 answer your question? If so, please mark his answer as correct. Thanks!

qubit gravatar imagequbit ( 2013-01-20 00:50:04 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2012-02-23 18:57:09 +0200

drone27of1 gravatar image

updated 2012-02-23 19:02:19 +0200

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

edit flag offensive delete link more


Years later this bug still hasn't been fixed! It's now 10 years later and it's still broken! Is everybody at LibreOffice sound asleep?

James Burke gravatar imageJames Burke ( 2021-03-16 08:39:38 +0200 )edit

Question Tools


Asked: 2012-02-23 14:23:39 +0200

Seen: 3,088 times

Last updated: Feb 23 '12