How should excel Identify social security numbers: as a text, numbers, or date and time? Why?

Question

asked Dec 18, 2023 168k views

2 Answers

Hoijui · Answer 1 · 2023-12-21T09:00:42+0000

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.

How should excel Identify social security numbers: as a text, numbers, or date and time? Why?

Please log in or register to add a comment.

Please log in or register to answer this question.

2 Answers

Please log in or register to add a comment.

Please log in or register to add a comment.

No related questions found

Categories

Other Questions