Villeroy wrote:Calc can convert text to numbers (and vice versa) with a simple replacement.
1) Select the column(s) in question.
[X] Current selection only
[X] Regular expressions
This replaces any content with the same effectively re-typing all data.
The very procedure converts data into text if you apply number format "@" (text) before the replacement.
Brian_M wrote:... I've no idea how the conversion works ...
Brian_M wrote:This worked for me (although, as primarily an Excel user, I've no idea how the conversion works) - just blindly followed the instructions and it sorted me out perfectly, thanks!
Martin.Flynn wrote:Perhaps I've missed something in this post but should this not be solved with the operation "Data>text to columns"?
Opening a CSV is an import of sorts, and will convert numbers to numerical cell values where possible.tadin wrote:Thanks Villeroy, but there is no 'import' operation.
There is a csv (comma-separated-values) file that by definition has no formatting, and thus when saved treats all as text.
That apostrophe is the spreadsheet software's convention for indicating that content which looks like a number is in fact text. Same for Excel and Calc.tadin wrote:The file made by Excel precedes each cell with the " ' " (Hex 27) as text designator (I believe it is like"@" in Calc).
Already mentioned: Select the dates column and menu item data - text to columns. Select the columnn in the conversion dialog, an then pick the column type corresponding to the date format in use.tadin wrote:But the question is more general: How can one convert text columns into values?
The apostrophe is not part of the cell content as such, but rather a "type modifier" for the content.tadin wrote:And, why am i unable to remove the ' by replacing it? (The Calc does not find it!).
Users browsing this forum: Alex1, Google [Bot] and 30 guests