Episode 767 - #VALUE Errors

A question asks how to avoid #VALUE errors when a formula refers to a cell with a blank text value. In Episode 767, I will take a look at how these blank cells come to be, how to work around the #VALUE error and even a different approach to prevent the root cause of the problem.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 521 - Show Positives

Dermot sends in today’s question; a spreadsheet is showing zeroes as a dash, and positive numbers with a plus sign! It turns out that the custom number format has four zones, where you can specify different formatting for positive, negative, zero, and text values. Episode 521 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 481 - Leading CSV Zeroes

If you have a CSV file, you will always lose any leading zeroes when you open the file in Excel. This causes problems with zip codes and social security numbers. Episode 481 shows the non-Excel method for solving this problem.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 397 - Leading Zeroes

A much better way of showing leading zeroes. After episode 392, several listeners called in with a better better way to show leading zeroes for any number of characters. Episode 397 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 392 - Leading Zeroes

Have you ever tried to enter an ID number that starts with zeroes? Excel automatically removes the leading zeroes, making it impossible for your VLOOKUPs to work. Rather than resorting to using a Zip Code format, try one of the tricks in Episode 392 to make Excel keep the leading zeroes.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!