Place 0 in blank cell

		Microsoft Office Forums > Microsoft Excel > Excel
Place 0 in blank cell

FAQ

Thread Tools

Display Modes

06-19-2014, 02:53 PM

gebobs

Windows 7 64bit Place 0 in blank cell

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

=if(isblank(n2),0,n2)

Of course, this will have to be in another cell. If you absolutely need it to be in n2, then I'm pretty sure that will require coding.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
editing a number/text at one place and changes taking place wherever it appears	anurag.butoliya	Word	1	06-14-2014 06:27 PM
VBA code to select one word from a text in a cell and place that word in next cell	Shinaj	Excel	2	05-01-2014 01:50 PM
not showing blank cell	alw	Excel	4	03-13-2014 01:08 PM
won't show blank cell	bhum	Excel	2	01-28-2014 02:34 AM
How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank?	Learner7	Excel	1	04-25-2011 04:39 AM

Other Forums: Access Forums

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