View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
swingkittenva
 
Posts: n/a
Default How do I shorten a number?

I have a list of 10-digit numbers, but I want to apply a formula/function or
format the cells so that only the first 6 digits show up. Is that possible?