Hey guys,
Today I started having issues with Excel. I've been using Windows in the past for work, and now I switched to Mac. Basically I have a spreadsheet and I want to use values from one column (filled with yellow) and multiply it by a set number, just like on the picture. Whenever I try to use the multiplication formula, the #VALUE error is occurring. There are no spaces before, or at the end of the cell, I tried putting both cells in either "general" or "number" format. Tried literally tens of different tutorials, but nothing seems to work. I'm downloading the spreadsheet from a data provider, then it goes to Numbers and afterwards I convert it to Excel. I tried using the "Get info" method to open files in Excel right away, but this doesn't work either.
I'm downloading the spreadsheet from a data provider, then it goes to Numbers and afterwards I convert it to Excel. I tried using the "Get info" method to open files in Excel right away, but this doesn't work either.
Is that original data from the provider coming to you as a CSV file? Try right-clicking on the file to get the option of opening with Excel rather than with Numbers, which is the default, which is used if you just click on the file name in a Mac. But you do have the option with a right click to select Excel directly.
