Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.