Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-10-2015, 12:03 PM
Chuck_Ds Chuck_Ds is offline How to make Excel stop treating blank cells as zero Windows 7 32bit How to make Excel stop treating blank cells as zero Office 2007
Novice
How to make Excel stop treating blank cells as zero
 
Join Date: Jan 2015
Posts: 6
Chuck_Ds is on a distinguished road
Default

Thanks a million, Charlie!! It worked! Do you have a link that explains how and why this works? That way, I'll know how to apply it to other situations. I don't recall seeing many of those characters in any of the other formulas I tried while researching this. Maybe that's why none of them worked. This works perfectly, because when '0' is entered, I want it to do that calculation (which it does!) and it ignores the blank cells (which it should!).

How does it know to differentiate between 'blank' and zero?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make Excel stop treating blank cells as zero Excel VBA - Mandatory cells cannot stay blank? hussnainh8 Excel 9 12-28-2014 09:40 AM
Help with Subtotal(103, ) formula and blank cells zhl203 Excel 1 07-30-2014 03:40 PM
How to make Excel stop treating blank cells as zero want to make letterhead template with second page blank William Whitney Word 4 06-20-2014 05:59 AM
Join cells together separated by ; when some are blank leemoreau Excel 3 11-03-2013 11:22 AM
How to make Excel stop treating blank cells as zero How to stop correcting zeroes in cells ? kevin_ms Excel 4 09-14-2008 10:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft