Thread: ALPHANUMERIC
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shashidhar shashidhar is offline
external usenet poster
 
Posts: 5
Default ALPHANUMERIC

HI ALL

please help me in formating a column.
I would like to have it look like 001,001A

i.e
three numbers
or
three numbers and one text

how can this be done in data validation ?