How To Change Excel 2K Null to Zero

intrepid · Apr 15th, 2002, 03:09 PM

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

Asala42 · Apr 15th, 2002, 03:24 PM

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

Asala42 · Apr 15th, 2002, 03:25 PM

Oh,

That should work even if you have non-numeric data thrown in btw,

Adam

intrepid · Apr 16th, 2002, 07:09 AM

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.

Asala42 · Apr 16th, 2002, 07:32 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 15th, 2002, 03:09 PM	#1
intrepid New Member Join Date: Apr 2002 Posts: 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

Apr 15th, 2002, 03:24 PM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	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

Apr 15th, 2002, 03:25 PM	#3
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	Oh, That should work even if you have non-numeric data thrown in btw, Adam

Apr 16th, 2002, 07:09 AM	#4
intrepid New Member Join Date: Apr 2002 Posts: 2	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.

Apr 16th, 2002, 07:32 AM	#5
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	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