[Solved] LibreOffice - Data/Text to Columns not working
Posted: Tue Apr 17, 2018 3:43 am
I am running Ubuntu 16.04 and using LibreOffice 5.4.3.2.
I downloaded my purchase details from one of the 'Box Stores'. The download was a .csv file. The format of the 'price' field is like $12.95.
These 'numbers' are, in fact, not numbers but text. Since there is no way, that I know of, to convert text to numbers in LibreOffice Calc I have used the Data/Text to Columns menu item successfully in the past to get real numbers.
For some reason this is not working now. I have been highlighting the column I wish to process including the field name. I have then gone to Data/Text to Columns and then picked OK without changing anything. Nothing happens!
Am I doing something wrong here??
I downloaded my purchase details from one of the 'Box Stores'. The download was a .csv file. The format of the 'price' field is like $12.95.
These 'numbers' are, in fact, not numbers but text. Since there is no way, that I know of, to convert text to numbers in LibreOffice Calc I have used the Data/Text to Columns menu item successfully in the past to get real numbers.
For some reason this is not working now. I have been highlighting the column I wish to process including the field name. I have then gone to Data/Text to Columns and then picked OK without changing anything. Nothing happens!
Am I doing something wrong here??