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.
- Selected entire column
- 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