Place 0 in blank cell

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

FAQ

Thread Tools

Display Modes

06-19-2014, 05:10 PM

macropod

Windows 7 32bit Place 0 in blank cell

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,343

If you want to put 0s into blank cells:
• insert a 0 in to any cell
• copy the 0 to the clipboard
• select the destination range (even spanning cells that aren't empty, but not including cells that have formulae)

• use Paste Special>Values>Add

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« 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 10:40 PM.