| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
numeric data with restriction of data length
The suggestions given both work but be aware that Excel will accept 15 digit
numbers only. The 16th will be turned to zero. 1234567812345678 will become 1234567812345670 If you need the 16 digits the cell must be formatted as Text. Gord Dibben MS Excel MVP On Thu, 9 Aug 2007 07:50:27 -0700, kHuRRum HumaYun <kHuRRum wrote: how can i set a cell or column value to accept only numeric data with the restrition of 16 digit length ??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| character length in data forms | Excel Discussion (Misc queries) | |||
| Data Validation - Restriction | Excel Discussion (Misc queries) | |||
| Adding "fixed" data to variable length data | Excel Worksheet Functions | |||
| Data Validation List Length | Excel Worksheet Functions | |||
| length of character data | Excel Discussion (Misc queries) | |||
Threaded Mode
