#### in Excel cell
You open an Excel file and some cells show #### instead of the value. Here is a quick fix.
Excel formula showing as text instead of actual result – How to fix the problem
Once in a while everyone is bound to come across this problem. You type a formula in a cell, then you press ENTER. Bam! nothing happens. You check if a donut chunk went in to the key board and some how jammed the ENTER key. So press it again, this time harder. But nothing. Excel […]
CP037: Error error on the wall, How do I fix you all? – Understanding & Fixing Excel Errors
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 37th session of Chandoo.org podcast, Let’s debug ’em #VALUEs & #N/As.
What is in this session?
In this podcast,
- Introduction to Excel formula errors
- The easy kind: syntax errors
- The triky ones: # ERRORs
- Fixing errors – using IFERROR & ISERROR
- Error checking & debug options
- Using Errors deliberately – charts & data validation
- A challenge for you – produce #NULL error
- Conclusions
Quickly convert numbers stored as text [tip]
Here is a quick tip to start the week.
Often, we end up with a situation where a bunch of numbers are stored as text.
In such cases, Excel displays a warning indicator at the top-left corner of the cell. If you click on warning symbol next to the cell, Excel shows a menu offering choices to treat the error.
How would you customize Excel after installing? [poll]
Recently, I bought a new laptop, because my old Toshiba died down. After installing the OS and other necessary tools (like browser, skype etc.), I have installed Office 2010. Since Excel is my bread and butter, I like to customize it so that I can get more work done. So today,let me share how I […]
Excel’s Auditing Functions [Spreadsheet Risk Management – Part 3 of 4]
This series of articles will give you an overview of how to manage spreadsheet risk. These articles are written by Myles Arnott from Excel Audit Part 1: An Introduction to managing spreadsheet risk Part 2: How companies can manage their spreadsheet risk Part 3: Excel’s auditing functions Part 4: Using external software packages to manage […]
Auditing Spreadsheets? – Disable Direct Editing Mode to save time [quick tip]
For most of us, the prospect of inheriting a large, undisclosed sum of money is bleak. But we have high probability of inheriting a complex Excel workbook with 19 worksheets and 2300 rows of data and 195 formulas. The kind where entire rainbow colors are used to color code accounts receivable statuses. Then what do we do? We spend a whole afternoon (and then the rest of the month) breaking our head trying to figure out why the total revenues are only $ 41.2 million when profits are $ 99.23 million.
So how do we deal with our inheritance?
Here is a quick tip to help you get started. Disable “Direct editing mode“.