Get clear, concise, and accurate answers to your questions on IDNLearn.com. Join our knowledgeable community and get detailed, reliable answers to all your questions.

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.
Your participation means a lot to us. Keep sharing information and solutions. This community grows thanks to the amazing contributions from members like you. Find reliable answers at IDNLearn.com. Thanks for stopping by, and come back for more trustworthy solutions.