How to convert text to decimal in openoffice calc?

Posted by wurlog on Super User See other posts from Super User or by wurlog
Published on 2010-12-29T13:08:13Z Indexed on 2010/12/29 13:55 UTC
Read the original article Hit count: 178

Filed under:

convert

|

text-editing

|

openoffice-calc

I have a column which contains:

€ 53,28
€ 1.336,0
€ 69,90
€ 296,50
€ 899,00
€ 149,90
€ 697,40

and so on. I want to sum the column up, but for openoffice it is text and not a decimal.

What I did:

=SUBSTITUTE(F7,".","") to get rid of the the dot
|€ 1336,0|
=SUBSTITUTE(G7,"€","") to get rid of the euro symbol
| 1336,0|
=RIGHT(H7, LEN(H7)-1) to get rid of the blank
|1336,0|
=SUBSTITUTE(I7,",",".") to change the comma to dots
|1336.0|

and after that I copy the whole column and paste it as "unformatted text" only after these steps I get a number with which openoffice can work.

Isn't there an easier way???

© Super User or respective owner

Related posts about convert

Monitoring SQL Server Agent job run times

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Introduction A few months back, I was asked how long a particular nightly process took to run. It was a super question and the one thing that struck me was that there were a plethora of factors affecting the processing time. This said, I developed a query to ascertain process run times, the… >>> More
Convert Dynamic to Type and convert Type to Dynamic

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
public static class DynamicExtensions { public static T FromDynamic<T>(this IDictionary<string, object> dictionary) { var bindings = new List<MemberBinding>(); foreach (var sourceProperty in typeof(T).GetProperties().Where(x => x… >>> More
Need help in filtering the data with various condition and filling in scroll window GP

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I am filtering the data and displaying in scroll window. There are many combination to display this data by customer id, customer id and itemnumber, customer id, itemnumber, work and history condition. And from date and To date condition. My query is when I am selecting the customer id and… >>> More
Convert and convert back datetime in Django

as seen on Stack Overflow - Search for 'Stack Overflow'
I am parsing feeds using feedparser and I am trying to store updated or updated_parsed attributes of feeds in Django db. But it shows an error as [u'Enter a valid date/time in YYYY-MM-DD HH:MM[:ss[.uuuuuu]] format.'] Please tell me how to convert updated and updated_parsed such that it can be stored… >>> More
Redaction in AutoVue

as seen on Oracle Blogs - Search for 'Oracle Blogs'
As the trend to digitize all paper assets continues, so does the push to digitize all the processes around these assets. One such process is redaction - removing sensitive or classified information from documents. While for some this may conjure up thoughts of old CIA documents filled with nothing… >>> More

Related posts about text-editing

Text-Editing program : muti-search-replace/multi-regex?

as seen on Super User - Search for 'Super User'
I have a long and arduous text file, and I need to do lots and lots of the same search-replaces on it inside of selections. Is there a text editing program where I can do multiple find/replace (or regex) at one time? That is, I want to : (select text) - (do-find-replace-set-A) - (do other stuff)… >>> More
Rich Text Editing in Windows Forms

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using following text editor for my windows forms application http://www.codeproject.com/KB/edit/editor_in_windows_forms.aspx This works great and a wonderful control, however I am trying to accomplish one task i.e. I wanted to insert a custom tag to the underlying html for eg if user clicks… >>> More
Collaborative text editing in a web application

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a group of writers around the world all trying to work on one story. I want them to be able to work with each other like they would on google documents, but from within our application. Specifically, being able to see who else is working on the document and what they are changing in real time… >>> More
Rich-Text Editing of Word Documents on the Web via ASP.NET

as seen on Stack Overflow - Search for 'Stack Overflow'
My users upload Word 2007 documents to our site and I'd like to load them into a rich edit control of some kind so the users can make modifications/ comment, etc. What mechanisms are available to: load the Word document via ASP.NET, and parse/format/display the document in a rich editing control… >>> More
Text editing best practices (with tags, etc.)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, I want to create a text field with some text, that is styled with tags. Think of MS Word, some ext is bold, some is a headline, etc. The tags that style the text are not visible to the user, he just sees the text in bold. How do I preserve these tags? I mean when I backspace over the closing… >>> More