View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bill G. Bill G. is offline
external usenet poster
 
Posts: 3
Default Hiding number parts by cell formatting

Hello. I have several cells with numbers, whose digits range from 10 to 13.
I want to show only the last 10 digits for every number. Not actually delete
the first few digits, but have them not show, by cell formatting probably. I
have played a bit with custom cell formatting but there is few info on the
web about the signs that can be used and their function. Any advice?