How To Install Slide App:

How To Earn Money by Slide App:

Read More Topics:

How to Type More than 15 Digits in MS Excel?

If you are a regular user of Microsoft Excel then you might be in danger while typing more than 15 digits in a cell. If you type 1111222233334444 then it will be 1111222233334440. Or if you type 25127680876675435 then it will be 25127680876675400. Simply the digits after 15th place will be changed to zeros! Doesn't it seem peculiar?

Today I will explain when & why this problem occurs and how you can solve it easily.
When the Problem Occurs?
The problem occurs when you try to type more than 15 digits in a cell like below:
####-####-####-####
1234324545679876
But when you press Enter, the output will be 1234324545679870. Excel changes the last digit to a 0. And why someone needs to type more than 15 digits in a cell? It can't be a currency figure.
Usually when you type a Credit Card/ Debit Card/ BO Account Number you have to type 16 digits. And the calculation of excel doesn't allow you to type more than 15 digits. That's why it converts the last digits (after 15th place) into zeros.

Reason:

You may ask - why Excel restricts users to type 15 digits in a cell? I'm also searching for a satisfactory answer. I found the following reason from
Microsoft Support:
Excel follows the IEEE 754 specification on how to store and calculate floating-point numbers. Excel therefore stores only 15 significant digits in a number, and changes digits after the fifteenth place to zeroes.
I don't know what does it mean! :) Anyway, I can show you several ways to get rid of this problem . . .

Solution:

There are several ways through which you can avoid this problem. First I'd like to show you an easy way:

Method 1: Putting Inverted (') Before the Number when you type more than 15 digits in a cell, just place an inverted comma ( ' ) before that number. And that mark will not be displayed on the sheet after pressing Enter! Though it will be displayed in the formula bar. Look at the image below:

Method 1

I don't know why the inverted mark disappears automatically. But I can explain why the 16th digit doesn't change to 0. Because when you type ' before a number then Excel doesn't consider this value as Number. It maybe consider the cell as text. That's why it remains unchanged.

Method 2: Format the Cell as Text Maybe the 2nd method is more useful. Before typing more than 16 digits in a cell, you have to format those cells as text.
You need to select the cells first. Office 2003 users will find the Format Cell options from the Format Menu > Cells > Format Cells. And Office 2007 and 2010 users will get this as below:

Method 2

Format cell window is same in all version of MS Excel. After selecting the cells, you will just need to choose the Text option and then hit OK. That's it.
Now you will be able to type more than thousand characters in a single cell!

An XML Schema is a language for expressing constraints about XMLdocuments. There are several different schemalanguages in widespread use, but the main ones are Document Type Definitions (DTDs), Relax-NG, Schematron and W3C XSD(XML Schema DefinitionXML Document Type Declaration, commonly known as DTD, is a way to describe precisely the XML language. DTDs check the validity of structure and vocabulary of an XML document against the grammatical rules of the appropriate XML language.
An XML document can be defined as:
Well-formed : If the XML document adheres to all the general XML rules such as tags must be properly nested, opening and closing tags must be balanced, and empty tags must end with '/>', then it is called as well-formed .
OR
Valid : An XML document said to be valid when it is not only well-formed , but it also conforms to available DTD that specifies which tags it uses, what attributes those tags can contain, and which tags can occur inside other tags, among other properties.
The following diagram represents that a DTD is used to structure the XML document:
DTD can be classified on its declaration basis in the XML document, such as:
Internal DTD
External DTD
When a DTD is declared within the file it is called
Internal DTD and if it is declared in a separate file it is called External DTD

Hiding File/Folder : 

Hiding File/Folder

Viewing Hidden File/Folder :

Viewing Files/Folders

---

Read More Topics:

---

Read More Topics: