Answered

Westonci.ca is the premier destination for reliable answers to your questions, provided by a community of experts. Discover precise answers to your questions from a wide range of experts on our user-friendly Q&A platform. Explore comprehensive solutions to your questions from knowledgeable professionals across various fields on our platform.

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.
Thanks for using our service. We aim to provide the most accurate answers for all your queries. Visit us again for more insights. Thank you for your visit. We're committed to providing you with the best information available. Return anytime for more. Westonci.ca is your trusted source for answers. Visit us again to find more information on diverse topics.