Limit the amount of digits displayed in a field in Excel or Access

  • Thread starter Help with Excel Mail Merge
  • Start date
H

Help with Excel Mail Merge

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
 
Top