What is this Character?

sandy700

I've partially found out what it is, it is a unicode character, theoretica gave me the idea. 

I've still no idea what it is but the program collecting the data was inserting it.

After I altered my program, it went away.

km1500

I wonder if it is a code to indicate that the numbers after be treated as text data, not numeric

outtatune

Does this match what's going on in your worksheet?

https://spreadsheetplanet.com/remove-apostrophe-in-excel/

sandy700

outtatune said:

Does this match what's going on in your worksheet?

https://spreadsheetplanet.com/remove-apostrophe-in-excel/

That is exactly what is going on.

KingL2

The default autocorrect options in Libreoffice does some weird stuff with apostrophes and hyphens
e.g. by default, it gives me the "bad" version (just what I don't want) from
'’´ bad, ' good; 
– bad - good

but you can change it all to how you want it in the autocorrect settings e.g.
https://help.libreoffice.org/latest/en-ZA/text/shared/01/06040100.html

dogmaryxx

Unicode Character 'APOSTROPHE' (U+0027) https://www.fileformat.info/info/unicode/char/0027/index.htm

km1500

In the excel spreadsheet simply highlight all the cells that you want the apostrophe removed from, right click and choose format and format the cells to number (because with the apostrophe they will be formatted as a text)

Chino

Next time you see a character you don't recognise, try pasting it into an online ASCII to hexadecimal converter. If you had done that with your character, you would have seen that it's an apostrophe.

For example, https://onlinehextools.com/convert-ascii-to-hex gives the following output for your original example of '21.44

0x27 0x32 0x31 0x2e 0x34 0x34