View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Help with Excel Mail Merge Help with Excel Mail Merge is offline
external usenet poster
 
Posts: 1
Default Limit the amount of digits displayed in a field in Excel or Access

I am creating a mail merge document using data that i filtered from an Access
Database. The data is displayed as 8 digits and automatically begins with two
zeros. I only want the last 6 digits to be displayed in my mail merge
document. How do i get only the last 6 digits to display when merging my data?

Thanks