answersLogoWhite

0

because if u do it as number then the 0 at the start would automatically be removed so u write in text otherwise the data would be wrong

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What indicates the type of data that can be stored in a field?

The data type, like Number, Date, Time, Text etc.


Is blob a real number?

yes blob is a real numberBLOB. The value is a blob of data, stored exactly as it was input. So it could be text or numbers.


What is a type check on a database?

Checking that data types are correct for what they are needed for. If data types don't match or are of the wrong type, it can cause problems. Dates should not be stored as text for example.


What happens when text is entered into a number field?

A number field will not accept text. If it does accept text, then it cannot be a number field. Text fields can accept digits, but number fields cannot accept other text. They will only accept digits and other numeric components, like a decimal point for example. Sometimes you will define a field for numbers, such as phone number or code numbers to be text fields. In fact, that is what you should do for that type of data. You never do calculations with phone numbers, like adding them or getting averages, so they can be stored in text fields, as there is no need for them to be stored in number fields. Also, a zero at the start of a phone number, would disappear if entered into a number field, and it would also not allow things like spaces or brackets.


What is a database cell?

A database cell is a single piece of data stored at the intersection of a row and a column in a database table. It represents the smallest unit of information that can be stored in a database. Each database cell typically contains a specific data value, such as a number, text, date, or other data type.


What types of data can be stored in a text data type field?

A text data type field can store alphanumeric characters, such as letters, numbers, and special symbols. It is suitable for storing large amounts of text data, such as descriptions, comments, or notes. Text data types can hold variable lengths of text, depending on the database system used.


Why is the telephone number stored as text on an access database?

Some telephone numbers starts with number 0 (zero) or the country code with + marks (If you type the full number properly). For instance a number like 0094111234567 or +94111234567. If this number is stored under the "Number" data type, two things can happen. 1. Default "Number" field does not support this size of data. You have to change the Filed Size to "Double" in order to accommodate this telephone number. 2. Zero (0) in the front will get removed automatically! So To prevent these issues you can use the data type as "Text" Hope this Helps!


What data type should you choose for a zip code field in a table?

You should choose a data type that can accommodate a zip code, such as a string/text data type with a set length to match the format of zip codes in your region. This allows for both numerical and special character values to be stored.


What device converts text or images on an original document into digital data that can be stored and processed by a computer?

bitmap


What happens if you convert memo data type to text?

When you convert a memo data type to text, any text stored in the memo field will be converted to plain text format. Any formatting, such as line breaks or special characters, may be lost during this conversion.


What are 5 types of data that can be stored in a cell in an excal spreadsheet?

Text, Date, Time, Logical and number. The numbers can be formatted lots of ways, like as currency or percentage. The number types are all number types, just formatted differently.


Is text an access data type?

No, "text" is not an access data type. In Microsoft Access, commonly used data types include Text, Number, Date/Time, Memo, and Yes/No among others. Text is used to store alphanumeric data such as names or descriptions.