I am new to Libre Office and am trying to import a csv file into a spreadsheet. Once imported, the dollar figures have a ’ in front which seems to mean that they are text not numbers.

I have tried to change the formating but it does not seem to work.

The help section does not seem to help as it only shows how to change numbers to text, not vice versa.

Can anyone help as I really need to get these columns into number format.

Thanks for any help.

i have a large table with lots of zeros. a lot of formulas did not work on the zeros

for example:

one row consists of 52 zeros and one time number 710. as average is gives 710, as a mean it shows 710 and as minimum it gives 710.

it looks like the software does not recognize the zeros as numbers.

i checked if the numbers where preceded by a ’ and could be interpreted as text. this is not the case

however; when i change some zeros into 1’s the average, mean and min do not change. they stay 710

i have checked the formulas that calculate the average and median and the range is correct.

i have selected the whole table and formatted the cells within the table as numbers

i rechecked the cells and now it shows that before all zeros there is a " ’ " .

i used the find and replace function to search for every " '0 " and replace it with a zero. the problem is that it does not find any cells containing " '0 " while i see them in my screen.

dont know what to do anymore…

am i missing something?

or is it a bug?

please help

=== Start Editing

Would the one who edited the very old question recently, please, clearly mark what he (f/m) changed. Otherwise a modification/enhancements of the answers are uselessly aggravated. (@Lupp }End Editing===