Created attachment 110509 [details] List of numbers with periods and hyphens unreplaceable in batch After importing an XL spreadsheet, I found the author had used periods to note telephone numbers (eg. 999.999.9999). As I needed unbroken numbers for my purposes, I attempted to remove the periods using Find and Replace and found I could not. I attempted to turn the numbers into text using the Format->Cell->Text menu items. I tried removing Direct Formatting. No joy. It appears that there is no way to bulk edit these periods or (I later discovered) hyphens from a cell once it is formatted that way.
Which version of LibreOffice do you use? With version 4.4.0.0.beta2+ under Ubuntu, replacing the dot and the hyphen by nothing produces numbers (right aligned in the cells). Same result with version 4.3.6.0.0+ Note: take care to use search&replace dialog without "Regular Expressions" checkbox checked, because the dot has a special meaning when used as regular expression. Set status to NEEDINFO. Please set it back to UNCONFIRMED once you have provided requested informations. Thank you for your understanding. Best regards. JBF
I am using Version: 4.3.4.1. I tried modifying options to eliminate the possibility of the calc program interpreting the "find" parameters as a Regular Expression. No change in result. Thanks for the idea anyway, I would not have thought of that.
I think there are several ways to do it, maybe the best and secure in advance is the C). A 1) First replace dots with nothing. Results in numbers. A 2 a) using regular expressions convert numbers in text: Search: .* Replace: '& A 2 b) with Menu/Data/Text to column: Select the numbers column Menu/Data/Text to column Mark column head and in Column type box select Text. --------------------------------------------------- B) In one step using regular expressions: Search: (.*)\.(.*)\.(.*) Replace: '$1$2$3 --------------------------------------------------- C 1) Format cells with numbers as Text @ C 2) Doing a search and replace dots for nothing. Format cells as text must be done before search and replace, to avoid the conversion in true numbers. Take in account that change the format never change the cell content. I think it works so by design. For me not a bug. Please if you are not agree reopen it, but in this case I think it would a request for enhancement.
Nice to see this post here and thanks for sharing this to us. Deep Sleep Diabetes Remedy is the exact protocol specially created to help people who are suffering from type 2 diabetes and related health issues naturally. Get more about Deep Sleep Diabetes Remedy Review here. https://bunchmag.com/deep-sleep-diabetes-remedy-review/
The Halki Diabetes Remedy aims at reversing the damage done to the body by this particle matter and curing the body with the right diet and food. halki diabetes remedy reviews greatly helps to decrease the chances of type 2 diabetics by eliminating toxins in a perfect way. https://halkidiabetesremedy.guru