View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bdehning bdehning is offline
external usenet poster
 
Posts: 11
Default Limit Number in cell to 5 Digits

I have a Zip Code Table with numbers with 9 digits or more showing up.

How do I go about only allowing the field to show the first 5 numbers and
dropping the rest after 5?
--
Brian