Share via

Randomly appeared #NA and #VALUE errors

Anonymous
2019-05-04T12:28:58+00:00

The Time recording excel sheet of my work has been showing some abnormal behavior with #NA and #VALUE errors for a couple of weeks now. It was working well before that and the same exact file works well on a MacBook even now. Please help me!

I don't have the right to edit the formulae behind the cells or anything since it is protected. I even tried checking it on online Office, but no luck there either.

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2019-05-04T12:53:29+00:00

    In most cases this issue is due to the "times" that you paste into the cell.

    You think you have a time, but the cell contains a text afterwards. See example in the screenshot below, in A2 there is a text, hence the error.

    Rewrite the time in the input cells manually, the fixes the issue in most case. If possible check also the number format of the cells.

    If you need further help, please select the cell with the error and make a screenshot (at best the whole screen) and include at min. the formula bar so that we can see the formula (as I did) and post it here.

    Have a look here how to include a screenshot in your post:

    https://answers.microsoft.com/en-us/windows/for...

    Andreas.

    Was this answer helpful?

    0 comments