Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert a BLANK value | Excel Worksheet Functions | |||
How can I check a cell for current date and insert it if blank? | New Users to Excel | |||
insert blank cells | Excel Worksheet Functions | |||
Insert Blank Line | Excel Discussion (Misc queries) | |||
Insert blank row and issue a sum | Excel Worksheet Functions |