ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Setting field size and type (https://www.excelbanter.com/excel-discussion-misc-queries/169624-setting-field-size-type.html)

tsap

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.

J. Sperry[_2_]

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.



All times are GMT +1. The time now is 04:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com