Place zeros in blank cells

[yoshimarine]

I have set up an Excel spreadsheet that will be used to input a variety of
data that will be imported into an Access database. The data is all numbers
and the reports that I run in Access can't do the calculations on blank
cells. There are usually 1500 records that are being imported and there are
9 columns that contain numbers, but not all will have a number entered. What
I need to find out is how to setup this spreadsheet to automatically place a
zero in all blank cells prior to importing without doing it manually. The
last time I did it, it took me about 20 minutes.

 

[Jim Thomlinson]

Highlight the 9 columns. Hit the F5 key. Click Special... in the bottom left
corner. Select Blanks. All of the blank cells will now be highlighted. Type
0. Hold down the Ctrl key and hit <Enter>. Zero should now be entered in all
of the blank cells...

 

[Kevin B]

This might do the trick for you, assuming that the data is arranged as a data
table.

Move to a location in the data table and press either these keystroke
combinations:

Using the number keys at the top of the keyboard
<Ctrl> + <Shift> + 8

Or using the keys on the Num Pad
<Ctrl> + *


This will select the entire table, blanks and all.

Now press <F5>, click the SPECIAL command button and then click the BLANKS
option button. Click OK. Now only the blank cells are selected.

Type a 0 (zero) and press <Ctrl> + <Enter> to place the zero in all selected
cells.

Hope this helps...