Register
Ivan inputs a phone number into cell A2 of an Excel workbook. He formats the cell using a phone number format: (555) 987-6543. Ivan copies cell A2 into a new workbook. What will be displayed in the new
208k views
4 votes
Ivan inputs a phone number into cell A2 of an Excel workbook. He formats the cell using a phone number format: (555) 987-6543. Ivan copies cell A2 into a new workbook. What will be displayed in the new workbook, and why?

User Andrei Ashikhmin
by
6.6k points

1 Answer

4 votes
The same format is retained. The reason being that parenthesis '(" were introduced at the beginning or prior to the numeric input. This will make excel consider the input data as General Data or in General Format

The display when copied is (555) 987-6543
User Simia
by
6.7k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

7.8m questions

10.5m answers

Other Questions

“What does it mean when we “rework” copyrighted material?”
The book shows how to add and subtract binary and decimal numbers. However, other numbering systems are also very popular when dealing with computers. The octal (base 8) numbering system is one of these.
Seven basic internal components found in a computer tower
Please help me ! All you do is just put it it all in your own words ! Please this is for my reported card!i don't know how to put it in my own words because my English is not that good!
describe an advance in technology that makes life more enjoyable. what discoveries contribute to this technology?
Link Copied!