The #Value error is displayed in Excel when it finds any spaces, characters, or text in a formula where it expects a number. Remove any invalid characters from the formula and keep numbers only. To fix this error, check if you’ve entered any formatted data like currency, dates, or special symbols in the formula. The same error can occur if the numeric value used is too small or large. If you have added the invalid number, you’ll find the NUM error on your spreadsheet.

The NUM error occurs when an invalid number is added to the formula. But, it is not an actual error it simply means that column isn’t wide enough to display the value you’ve inputted.įixing this error is simple, just increase the column width so that the value can be displayed in the spreadsheet. The first common error that users often encounter is a cell filled with hashtag characters. In this article, we’ll look at eight common errors of MS Excel and how users can resolve them. Otherwise you may face a lot of trouble in conducting your day-to-day activities. And it’s important to learn how to fix these errors. But, while using Excel, many users often encounter some common errors. MS Excel is indeed a popular application for creating spreadsheets, keeping accounting data, and tracking day-to-day activities in organizations.

Invalid reference error in excel