Welcome to Westonci.ca, the place where your questions are answered by a community of knowledgeable contributors. Discover reliable solutions to your questions from a wide network of experts on our comprehensive Q&A platform. Our platform offers a seamless experience for finding reliable answers from a network of knowledgeable professionals.

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

Sagot :

Answer:

as text

Explanation:

they are not quantitative so not numbers

they are not dates and times

View image narstarolor
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.