Thread: Data Validation twist
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carim[_3_] Carim[_3_] is offline
external usenet poster
  
Posts: 137
Default Data Validation twist
Sorry ...

I meant without VBA ...
otherwise with worksheet change event
ActiveCell.Value = Left(ActiveCell.Value, 1)

Thanks

Reply With QuoteReply With Quote