Place 0 in blank cell

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

FAQ

Thread Tools

Display Modes

06-20-2014, 12:40 PM

Mjpunj

Windows 7 32bit Place 0 in blank cell

Office 2010 32bit

Novice

Join Date: Jun 2014

Posts: 7

type a zero into a cell, copy it to your clip board, highlight the cells you want to replace blanks with zeros in, hit F5, click the radio button next to "blanks"; click OK, then hit CTRL+V

« 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 06:55 PM.