|
Post by aaronpawlak on Dec 26, 2017 7:47:38 GMT
Hello, I am completely new to all of this and looking around for help.I made an enforced switch to Linux 64-bit. I now find that the links don't work. Of course, I thought, the file structure's different. So I went in and pasted new links, precisely copying the system I'd used before. Sure enough, Calc now shows the right numbers.Here's the thing: the links aren't numbers anymore. If you try to perform an arithmetical function, you an error. So, are they text fields then? Well, I can concatenate them; they must be text. So, surely I should be able, at least, to extract the number with =VALUE. I try this and get ERR:502, indicating that the system doesn't recognize the contents as numbers.I've tested by using Software Explainer Video, in case there's a conversion problem with going from Windows to Linux. Still the same.How do I get my numbers out? Anybody? .I went through many resources but did not find any solution for this issues. Please help me out. Any help will be appreciated. Thank you.
|
|