| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting field size and type
How Do you set the field type and size? Example: I need to set the size to
9 characters and type to numeric. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Setting field size and type
It sounds like you're asking a question suited for Microsoft Access
(database). However, if you truly do want this for a spreadsheet, then add Data Validation to the cell(s), specifying "Whole number" for the allowed type, and 999999999 for the maximum. "tsap" wrote: How Do you set the field type and size? Example: I need to set the size to 9 characters and type to numeric. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Registry setting for default document type? | Excel Discussion (Misc queries) | |||
| Setting up Popup-Task type reminders In Excell 2003. | Excel Discussion (Misc queries) | |||
| Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) | |||
| Setting up a Custom type, User-defined, Default Chart | Charts and Charting in Excel | |||
| Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
Linear Mode
