Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do I insert a NULL value into a cell using the keyboard or a menu option?

For example, in some programs, typing CONTROL + 0 results in a null value being inserted and the text "NULL" being displayed, but this is not the same as typing NULL in the cell, since this would be treated as text.

share|improve this question
    
I'm not sure Excel even has the concept of a null value. Doesn't just deleting the cell's contents work? – Indrek Sep 4 '12 at 17:54
    
CSV fields have the concept of NULL if field delimiters are used and Excel handles CSV files, though poorly. However, the only way that I know to get a null value into the file is using Notepad. – Chad Sep 4 '12 at 18:50
    
Might be worth explaining why you want a NULL - in case there is a different way to the result you are after. – pnuts Sep 19 '12 at 1:25
    
Does your method (via Notepad) achieve anything other than a blank cell once in Excel? – pnuts Sep 26 '12 at 22:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.