MATERI TIK KELAS XI Kamis, 17 Mei 2012. MICROSOFT EXCEL A. ELEMEN-ELEMEN DASAR JENDELA KERJA MICROSOFT EXCEL. Baris Judul (Tittle Bar), bagian ini berisi nama file dan nama program aplikasi yang sedang kita aktifkan. Fonts Icons Wallpaper Microsoft Excel. Pada Insert tab, grup Charts, klik Pie dan pilih bentuk seperti contoh di bawah ini. Pie Chart Type.
![]() --> Symptoms
After you enter a long number (such as a credit card number) in an Excel cell, the number is not displayed correctly in Excel. For example,
Note
Default number format in Excel is General therefore you can display up to 11 digits in a cell.
Workaround
To work around this issue, use one of the following methods.
Method 1: Format the cell as text![]()
To do this, follow these steps:
Method 2: Use a single quotation mark
When you enter a long number, type a single quotation mark (') first in the cell, and then type the long number.
For example, type '1234567890123456789 and the quotation mark will not be displayed after you press ENTER.
Your opinion is important to us!Do not hesitate to tell us what you think of this article using the comment field located at the bottom of the document. This will allow us to improve the content. Thank you in advance!
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |