0
What does Excel treats phone numbers and social security numbers as?
Wiki User
∙ 9y ago
Initially it may treat them as numbers, but ideally they should be treated as text. This is because they are not like ordinary numbers as they may start with zero or have other characters in them or have spaces in them. Also, you will never want to do any calculations with them, so they do not need to be treated as ordinary numbers. For example, you would never multiply one phone number by another number. To ensure they are treated as text, you can format them to the Text format or put a single quote before them like this:
'0001556
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
Does a computer treat text any different that it treats numbers?
A computer treats all characters the same. Applications that run on the computer, like MS Excel, may treat text and numbers differently.
Why are dates right-aligned within a worksheet cell by default?
Excel right aligns dates within a worksheet because it treats dates as numbers.
What are identified with numbers in Excel?
Rows are identified by numbers in Excel.
Excel displays numbers as percentages?
Yes. Excel can display numbers as percentages. Do you have a question?
Is Excel better than Numbers?
The general opinion is that Excel is better than Numbers.
What are two or more selected cells that Excel also treats as a single cell?
Depending on what you mean, it could be a range, which is a group of cells in Excel, that can be referenced in a formula as a block, but they are not a single cell then. You could be referring to cells that have been merged, in which case Excel treats them as a single cell.
How high do the numbers on Microsoft Excel go?
65,536! 1,048,576 with Excel 2007
What are data types in excel?
text and numbers
What things did Maya excel in?
Numbers, Agriculture
How do you get integer numbers in excel?
ask google
Does Excel store dates and times using text?
No. Dates and times are stored as numbers in Excel.
What is revenue in excel?
Revenue is how much is earned, like in a business. As Excel deals with numbers, then calculating revenue is something that is regularly done in Excel.
