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 ^
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!
This worked for me on digits I cut and pasted from a credit card statement. It formatted all my text numbers to digit numbers. Have you updated to the latest version of LibreOffice?
Super clear and super useful, thank you Very much!
You're welcome Marco, I'm glad it's helpful! I appreciate your feedback 👍
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".
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 ^
Thanks for the comment! I'm glad you discovered and shared what worked for currency values
@@officenifty I have the same problem, but the above poster's comment was truncated -- so I do not have the solution!
we asked for Macro code to display numbers to words and you wasted four minutes showing how to make Orange juice.
A wonderfull example, why libre is useless for normal users.
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!
This worked for me on digits I cut and pasted from a credit card statement. It formatted all my text numbers to digit numbers. Have you updated to the latest version of LibreOffice?