Forum Discussion

Kociel's avatar
Kociel
Copper Contributor
Nov 07, 2023

Unsolvable #Value error

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 ...
excel
mathetes's avatar
mathetes
Silver Contributor
Nov 07, 2023
Numbers, when in a cell, are typically justified on the right of the cell. Your "numbers" in column O, are left justified, suggesting to me that they're actually text. Assuming that's the case, use the VALUE function to convert them to actual values.
  • Kociel's avatar
    Kociel
    Copper Contributor
    Nov 07, 2023

    mathetes Thank you for your reply! Unfortunately, when I tried to do as you said, I'm seeing "#VALUE" error again (when using formula) and when "clicking" to do so, nothing changes... Also, I can't even change the decimal format, it's stuck at 3... It seems like this is locked and no changes can be made to this cell/column...

    • mathetes's avatar
      mathetes
      Silver Contributor
      Nov 07, 2023

      Kociel 

      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.

       

      • Kociel's avatar
        Kociel
        Copper Contributor
        Nov 07, 2023
        Yes it is. I've tried doing this in Excel, Numbers, everything...

Resources