Hello. Am little new at this open source software. I received a CSV sales file showing product codes and $sales delimited by commas. Except the person that created the file actually appended a $ to the front of the sales number in each field. This makes the number a text field when I import it into calc because it looks like $411.01 for example
I tried “replace all” with $ to remove and nothing to add… but Librecalc then inserts a ’ in place of the $ which changes nothing.
How do I get rid of the $ and cause the text field to become a number or currency field?
Many thanks for your advice.