Share via

Excel formula showing 0 instead of result

Anonymous
2022-07-30T01:43:07+00:00

Hi,

Whenever I try to use a formula as simple as SUM in excel, the results show 0. This happens every time I copy the data from another source, so in order for it to work, I have to go and manually enter all the data.

I have tried:

  • Pasting the data as a value number. It doesn´t work.
  • Using a formula to change the format so it recognizes the numbers. It doesn't work.
  • Enabling " interactive calculation" from options. It doesn't work.

The only way it works is by manually entering all the numbers, which is really tiresome and time-consuming as well.

How can I avoid this from happening?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-08-08T19:35:15+00:00

    thanks but I'm not using an array formula

    6 people found this answer helpful.
    0 comments
  2. Andreas Killer 144K Reputation points Volunteer Moderator
    2022-08-09T14:11:14+00:00

    Hi, that's what I tried first but it doesn't work

    And you are sure that the calculation method is set to automatic?

    Change formula recalculation, iteration, or precision - Excel

    If so, show me such a file that doesn't recalculate till you re-enter the values.

    IMPORTANT: Zip your file!
    https://support.microsoft.com/en-us/windows/zip-and-unzip-files-8d28fa72-f2f9-712f-67df-f80cf89fd4e5

    Login to https://onedrive.live.com (Use the same Login ID and password as for this forum).
    Click Upload in the top and choose your file.
    After uploading, right click the file and choose Share.
    Click Copy Link in the lower left edge (no need to enter an email).
    Copy the link and paste it here.

    Andreas.

    5 people found this answer helpful.
    0 comments