Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Adding zero's to blank cells

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

    Default

    Hello to all!! Is it possible to selcect all of the blank cells in a given range (multiple columns/rows) and insert a 0?

    Any advice will be greatly appreciated.

    Thanks!!!

    Anthony

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes, select your range, choose the Edit | Go To... | Special... Blanks menu command, type 0, and press Control+Enter.

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey Mark, thanks for the response!!!. When I select the range, it appears that it will only allow a zero to be placed on a line that has a formula and not in any other cells. When I select a few blank cells and follow the steps that you outlined, it tells me that no blank cells were found. Any other suggestions??? Thanks again!!!

    Anthony

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

    Default

    I actually just found out something very interesting. The data that I'm trying to do this with was copied to Excel from an Access table. The cells appear to be blank, which had me wondering as to why Mark's method wasn't working. I then went into those cells and selected "clear contents". It now works............BUT WHY???

    Any thoughts?

    Thanks

    Anthony

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-12 05:27, Anthony G wrote:
    I actually just found out something very interesting. The data that I'm trying to do this with was copied to Excel from an Access table. The cells appear to be blank, which had me wondering as to why Mark's method wasn't working. I then went into those cells and selected "clear contents". It now works............BUT WHY???

    Any thoughts?

    Thanks

    Anthony
    I suspect that your data contained either spaces (" ") or the null text string (""). These are quite different from an empty cell. One way to eliminate these values is to select them and use the Data | Text to Columns... menu command.

    [ This Message was edited by: Mark W. on 2002-03-12 06:28 ]

Some videos you may like

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
  •