View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JcR
 
Posts: n/a
Default enter 5 in 1 cell, show first 3 in other cell

I want to be able to:

enter a 5 digit number into in cell a1

have the first 3 digits appear in cell a2

Thanks