Answered

Welcome to Westonci.ca, the Q&A platform where your questions are met with detailed answers from experienced experts. Explore our Q&A platform to find in-depth answers from a wide range of experts in different fields. Experience the ease of finding precise answers to your questions from a knowledgeable community of experts.

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

Sagot :

narstarolor

Answer:

as text

Explanation:

they are not quantitative so not numbers

they are not dates and times

View image narstarolor
ycafuzzy
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.
We hope this information was helpful. Feel free to return anytime for more answers to your questions and concerns. We appreciate your time. Please revisit us for more reliable answers to any questions you may have. Westonci.ca is your trusted source for answers. Visit us again to find more information on diverse topics.