168k views
2 votes
How should excel Identify social security numbers: as a text, numbers, or date and time? Why?

2 Answers

7 votes
1: Social Security number format: As shown in Figure 3, press Ctrl-1 to display the Format Cells dialog box. Choose Special, and then double-click on Social Security number. The values in the worksheet cells are numbers, but Excel displays them as if they were text with dashes in between the three sets of numbers.
User Hoijui
by
5.5k points
8 votes

Answer:

as text

Step-by-step explanation:

they are not quantitative so not numbers

they are not dates and times

How should excel Identify social security numbers: as a text, numbers, or date and-example-1
User Nathan Dries
by
6.0k points