View Single Post
 
Old 07-12-2006, 08:29 AM
deekadelic deekadelic is offline
Novice
 
Join Date: Jul 2006
Posts: 1
deekadelic
Default How Do I Replace Nulls With Zeros?

There are some 38,000 cells on this spreadsheet I'm working with; and some contain values and some are empty. I need a quick-and-easy method to take any cell that doesn't have a value in it, and stick a value of "0" in it, so that I can upload the spreadsheet to a table that doesn't allow nuls. I know this must be very easy; but I can't seem to get my brain around it today.

Help!

thanks

d
Reply With Quote