Place 0 in blank cell

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

FAQ

Thread Tools

Display Modes

06-20-2014, 03:38 PM

macropod

Windows 7 32bit Place 0 in blank cell

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,512

Quote:

Originally Posted by Mjpunj

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

F5 just displays the 'Goto' box, with no radio buttons or 'blanks'. And what though have you given to the effects this has on formulae in the destination range?

__________________
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 08:13 AM.