Changing an Existing Field from One Type to Another
You can change the type of some fields to another. Automatic counter, location, and address fields, and any fields you access in a shared database can’t be changed to a different type.
The information in the table below also applies to changing the data type of columns in simple list fields and columns in the notes section of related data fields.
 
Convert from:
Convert
to:

Text
Number
Choice
Checkbox
Time
Date
Duration
Currency
Rating
Phone
Other list fields
Calculation; Encrypted; Media
Text
 
  •
  •
  •
  •
  •
  •
  •
  •
  •
  •
  •
Number
  •
 
  •
  •
 
 
 
  •
  •
  •
 
 
Choice
  •
  •
 
  •
  •
  •
  •
  •
  •
  •
  •
 
Checkbox
  •
  •
  •
 
 
 
 
 
 
 
 
 
Media
  •
 
 
 
 
 
 
 
 
 
 
 
Time
  •
 
  •
 
 
 
 
 
 
 
 
 
Date
  •
 
  •
 
 
 
 
 
 
 
 
 
Duration
  •
 
  •
 
 
 
 
 
 
 
 
 
Calculation
  •
 
 
 
 
 
 
 
 
 
 
 
Currency
  •
  •
  •
 
 
 
 
 
 
 
 
 
Rating
  •
  •
  •
 
 
 
 
 
 
 
 
 
Encrypted
  •
 
 
 
 
 
 
 
 
 
 
 
Phone number
  •
 
 
 
 
 
 
 
 
 
 
 
Email address
  •
 
 
 
 
 
 
 
 
 
 
 
URL
  •
 
 
 
 
 
 
 
 
 
 
 
IM account
  •
 
 
 
 
 
 
 
 
 
 
 
To change an existing field from one type to another:
1
Select a column name in table view.
2
Click Triangle icon near the right edge of a column header.
3
Choose Change To, then select a field type from the list.
 
Was this topic helpful? Send feedback.