How To Change Excel 2K Null to Zero

intrepid

New Member
Joined
Apr 14, 2002
Messages
2
Hi Everyone:

After importing results from an Access 2K query, I'm looking for a method to change null-filled cells to 0 (zero). Does not matter if it's VB or macro -just as long as it work's!

Thanks in advance.

Mark Molnar
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Hiya,

A simple way would be to copy a 0 in a cell, highlight the range of numeric data, then hit editpaste specialadd. Should do the trick.

Adam
 
Upvote 0
I should have added that the sheet I am working with has over 2,000 rows and about 50 columns. While I think "cut/paste" is a good solution, it would not be particularly efficient here since nulls are scattered randomly throughout the active range.

Thank you for the reply though.
 
Upvote 0
Hey again,

Why not highlight the entire 50x2000 range when you paste? 0's will fill in the blanks and should not effect your existing entries.

Adam
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,949
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top