How to Convert Text to Numbers in LibreOffice Calc

[marcociolli]

Super clear and super useful, thank you Very much!

[ak-hzfqnpz]

This helped for getting rid of those ' characters, annoying that it won't format with the default options if it is a mix of "numbers" and "text".

[geoffrundlett]

helpful but left me wondering how to build the regular expression to search for "text" that appears like a dollar figure. My text looks like $12.34 so when I used the expression ^[0-9] it found nothing to replace. It worked on sample text I typed in as '001 and '002 like you showed but didn't find '$12.34 EDIT: turns out my funky data responded better to simply [0-9] without the carrat ^

[Hazifsaj]

we asked for Macro code to display numbers to words and you wasted four minutes showing how to make Orange juice.

[knuthbenjamin]

A wonderfull example, why libre is useless for normal users.

[tkarlmann]

Not a universal solution! Calc does not recognize LibreOffice for cut & paste, so it must be imported. Calc puts that ' in front of everything; and your solution works only for single digits. When I try your solution on Dollar amounts "$1234.99", it wants to replace EVERY numerical digit with "[0-9]". Please assist!