Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2014
    Posts
    2

    Unanswered: If the cell has something in it, leave it there, if not return "null"

    Any help?

    Thanks.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    ?
    if there is nothing there then the cell is NULL, or do ytou want to set a strign value of 'null'

    are you trying to retrieve a value for a cell or set a value
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Apr 2014
    Posts
    2
    If there is something in the cell, I want it to display what is there. If there is nothing in the cell, I want it to say "Null" as text.

    Thanks.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so you could use a custom format
    you could use an if statement
    you could run a fragment of VBA
    however Id cautiuon and suggest you leave well alone. putting in text can cause problems especially with summation or statistical functions
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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