if cell is blank insert a zero

G

Guest

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.
 
G

Guest

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.
 
S

Stephen

JK said:
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.
 
G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top