How To Change Excel 2K Null to Zero
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: How To Change Excel 2K Null to Zero

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,305
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,305
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Oh,

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

    Adam

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,305
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com