Do not leave any blank cells in the spreadsheet. Use a single period ( . ) to indicate missing values. If there are several types of missing data, use letters to code the different types. For example, on a survey, you may use D = Didn't know, R = Refused to answer, B = Left question blank.