Unable to remove $ and £ from column.

Version: 6.4.7.2
Build ID: 1:6.4.7-0ubuntu0.20.04.14
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

Unable to remove the currency sign from a column.

  1. Selected entire column
  2. FORMAT>CELLS>
    The Category is already ‘Number’ and the format is ‘General’

I had one test number and so I changed it to currency and the $ sign is there. go and try again the above and nothing is changed except that one test entry.

I imported this calc document and I’m sure that is the problem it was in csv format

What do you see in the input bar when you click on one of the affected cells?

What happens if you click on one of the affected cells and press Ctrl+M to set the cell to default formatting?

Select View | Value Highlighting - text cells are formatted in black, formulae in green, and number cells in blue, no matter how their display is formatted

This page should help How to convert number text to numeric data