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

User Ishan Khare
by
7.1k points

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
6.3k 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
7.2k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

7.6m questions

10.2m answers

Other Questions

“What does it mean when we “rework” copyrighted material?”
The book shows how to add and subtract binary and decimal numbers. However, other numbering systems are also very popular when dealing with computers. The octal (base 8) numbering system is one of these.
Seven basic internal components found in a computer tower
describe an advance in technology that makes life more enjoyable. what discoveries contribute to this technology?
Disadvantages of using animation in advertising? advantages and disadvantages of using animation for education? advantages and disadvantages of using animation in entertainment?
Link Copied!