Ask Your Question
0

Calc problem when change data type [closed]

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

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

Comments

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 +0100 )edit

1 Answer

Sort by » oldest newest most voted
1

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

drone27of1 gravatar image

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

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

Question Tools

Stats

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

Seen: 2,166 times

Last updated: Feb 23 '12