if cell is blank insert a zero
 

Does anyone out there know how to auto-insert a zero into a blank cell?

I have a spreadsheet that I need to import into an Access db. It's not a
huge spreadsheet, but it's not small either. I have 600 rows and 10 columns.

Example: this is what it looks like...

date salesperson cat1 cat2 cat3 cat4 cat5
etc...
1/1/01 Jason 10 5 1
6
1/1/01 Jason2 5 7 6 4
9
1/2/01 Jason 2 4
4 8
And so
on................................................ ..............................................

I need to convert all of the blank cells into zero's.
This must be done either before the import or in Access after the fact
(whichever is easier.)

I just can't seem to think of a way to do this... Your help would be greatly
appreciated.

if cell is blank insert a zero
 

Edit Goto... Special Blanks OK
Then touch:
0 CNTRL-ENTER

using CNTRL-ENTER instead of just the ENTER key will enter the zero in ALL
the selected blank cells.
--
Gary''s Student - gsnu200751


"JK" wrote:

Does anyone out there know how to auto-insert a zero into a blank cell?

I have a spreadsheet that I need to import into an Access db. It's not a
huge spreadsheet, but it's not small either. I have 600 rows and 10 columns.

Example: this is what it looks like...

date salesperson cat1 cat2 cat3 cat4 cat5
etc...
1/1/01 Jason 10 5 1
6
1/1/01 Jason2 5 7 6 4
9
1/2/01 Jason 2 4
4 8
And so
on................................................ ..............................................

I need to convert all of the blank cells into zero's.
This must be done either before the import or in Access after the fact
(whichever is easier.)

I just can't seem to think of a way to do this... Your help would be greatly
appreciated.

if cell is blank insert a zero
 

"JK" wrote in message
...
Does anyone out there know how to auto-insert a zero into a blank cell?

I have a spreadsheet that I need to import into an Access db. It's not a
huge spreadsheet, but it's not small either. I have 600 rows and 10
columns.

Example: this is what it looks like...

date salesperson cat1 cat2 cat3 cat4
cat5
etc...
1/1/01 Jason 10 5 1
6
1/1/01 Jason2 5 7 6 4
9
1/2/01 Jason 2 4
4 8
And so
on................................................ ..............................................

I need to convert all of the blank cells into zero's.
This must be done either before the import or in Access after the fact
(whichever is easier.)

I just can't seem to think of a way to do this... Your help would be
greatly
appreciated.


In Excel, select the whole area of interest. Then do
Edit Go To Special Blanks OK
Then type 0 and hold down Ctrl whilst pressing Enter.

if cell is blank insert a zero
 

Wow! A whole new function I was not aware of!
I love this site! The help I receive in such a short amount of time is
amazing!

Thanks so much!



"Gary''s Student" wrote:

Edit Goto... Special Blanks OK
Then touch:
0 CNTRL-ENTER

using CNTRL-ENTER instead of just the ENTER key will enter the zero in ALL
the selected blank cells.
--
Gary''s Student - gsnu200751


"JK" wrote:

Does anyone out there know how to auto-insert a zero into a blank cell?

I have a spreadsheet that I need to import into an Access db. It's not a
huge spreadsheet, but it's not small either. I have 600 rows and 10 columns.

Example: this is what it looks like...

date salesperson cat1 cat2 cat3 cat4 cat5
etc...
1/1/01 Jason 10 5 1
6
1/1/01 Jason2 5 7 6 4
9
1/2/01 Jason 2 4
4 8
And so
on................................................ ..............................................

I need to convert all of the blank cells into zero's.
This must be done either before the import or in Access after the fact
(whichever is easier.)

I just can't seem to think of a way to do this... Your help would be greatly
appreciated.