dropping zeros..followup

S

scott

I got a little help on this but I am still in need of help.

I have a file that I am comparing with a customer file.

The customer file has all the codes without 0's like this.

123456
111111
222222

Our report has it with 0's like this.

0123456
000111111
00222222

I need to compare these 2 fields to bring back which codes
do not match.

I am thinking the easiest way is to drop the 0's in front
of our report then compare..

1. How do you drop leading 0's?
2. Is there an easier way to do this?

The field contains TEXT and numbers...some of the codes are like
this.

D123456 and E456789

Thanks
Scott
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dropping leading 0's? 8
Link a text box based on drop down box with four options MS Word 365 0
Mail Merge Directory Conditional Page Break 0
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Possible to Combine reports to's to a single box? 0
VBA - (re-) Set a Table Style 2

Top