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