In Spreadsheet.com it is easy to configure the data in each cell or column with data types. Use column-level data types to customize your worksheets. Plus, with column-level data types, you can restrict what users can input to only the type and formatting of data you want.
For instance, set columns to currency and date data types in a sales tracking worksheet. Or set columns to the user, icon, and select data type for the owner, RGB, and status columns in your project plan.
How to Edit a Column's Data Type
There are multiple ways to edit the data type of a column, cell, or range of cells that are detailed in our set of articles on data types. Also, there are some unique behaviors when converting the data type of existing data to keep in mind. But, changing the data type of a column is easy and noted below.
First, select the column you wish to change and navigate the Update Column dialog box. You can open this Update Column dialog box by right-clicking on the column and selecting Edit Data Type, by clicking on the drop-down arrow in the column title, by double-clicking on the column name, by right-clicking the column in the table header row, the drop-down in the table header row, or via the Edit Data Type button in the toolbar.
Next, choose the data type that you would like to change that column to and configure any data type settings (like the number of decimal places in a percentage, currency symbol to use, or select options to choose from). When you are done, click Update.
Setting a Column to Strict
All Data types can have Strict enabled. Selecting the Strict checkbox for a column will restrict users to input only data that matches that data type.
Note: setting a column's data type to strict removes all data that does not match that data type.
The primary column of your worksheet has a limited range of data types available. A worksheet's primary column is the column used to uniquely identify rows and is demarcated with a key icon: . Because this is the unique identifier for your worksheet, if you try to change the data type of this column you will only see the following options:
- Date & time
- Column formula