enter number into table

  • Thread starter Thread starter reidapple
  • Start date Start date
R

reidapple

Hi,

how do i enter number that starts with 0 into the table? like a phone number
for example?

thx
 
numeric data types do not carry leading zeros or any other formatting
information. You options are to use a text data type or use the Format
function when you present the number to a user.
 
Hi,

how do i enter number that starts with 0 into the table? like a phone number
for example?

thx
Click to expand...

"Numbers" such as telephone numbers or Zip codes are not really numbers; you
won't ever be doing arithmatic operations with them, or incrementing them as
you might do with an invoice number. Use a Text datatype instead of any sort
of Number datatype for them.

Another reason to use text instead of number is that a Number field of the
default Long Integer datatype is limited to be no larger than 2147483647 - so
a phone number in any area code larger than 214 will not fit.
 
Back
Top