Thread: [Solved] Place 0 in blank cell
View Single Post
 
Old 06-20-2014, 03:38 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Mjpunj View Post
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]
Reply With Quote