Thread: numeric data with restriction of data length
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default numeric data with restriction of data length
Use Data validation

Custom

Formula:

=Len(A1)=16

which will allow ONLY length of 16



"kHuRRum HumaYun" wrote:

how can i set a cell or column value to accept only numeric data with the
restrition of 16 digit length ???


Reply With QuoteReply With Quote