Wrong data type in Calc even after text to column

Calc gives wrong data type even after text to column which should fix thiswrong data type problem.xlsx

Complement

THANKS YOU for all the effort but,… That is exactly what I do except mine does not display the ’ before the number making it text. When I do the Text to column, mine does not get fixed, the problem goes on.

My version 6.2.0? did not respond at all when clicking on the “launch” icon for Calc or any of the components, so in order to again use office, I installed 6.2.4 now I have access but with these problems. Do you suggest a complete uninstall everything? Regards

Any details to see the problem?

simple column of numbers from internet, can not devide or multiply add subtract even after trying the text to column fix gets wrong data type but just basic numbers

Can Calc do this: =D2/D3 ? what am I doing wrong?

still no way e.g. for me to see the problem… do you use correct format when converting, including correct decimal separator (like choosing proper locale or en-US)? Could you edit the question to provide a sample file?

Using US english and US beyboard win10 with latest updates… how can I send a jpg of file to the help?

Edit the question and use toolbar buttons there.

Hi I have sent the file thanks

I don’t see problems with applying Text To Columns to the data in your file; here is a screencast I created for that. Please clarify which cells do you try to convert, and which settings are you using there.

THANKS YOU for all the effort (Youtube video!!) but,… That is exactly what I do except mine does not display the " ’ " before the number making it text. When I do the Text to column, mine does not get fixed, the problem goes on.

My version 6.2.0? did not respond at all when clicking on the “launch” icon for Calc or any of the components, so in order to again use office, I installed 6.2.4 now I have access but with these problems. Do you suggest a complete uninstall everything? Regards

The whole time Microsoft office is asking me for a registration key, can this affect the working of Libreoffice?
Do you suggest a complete uninstall of Libreoffice and start over?

Please provide the dialog screenshot

The point is that it only support English USA, now that I have removed British and South Africa English it responds as expected it actuaally calculate the result even with the ’ displayed as expected No need to even Text To Column… Regards and thanks a lot for persisting with me!!:grin::grin:

And Thanks Gilberto! That forced the issue!

In Format / Cells …