The strangest thing happened ... for the longest time my macro worked
well. One textbox queries a lot number which starts with a 0.

The target field is formatted as text:

Range("Z2:Z3").NumberFormat = "@"

All of a sudden the box removes leading zeros... Cant figure out why
.... the code realting to this hasnt changed.

How can I force the box to be text and leave leadign zeros alone?

Matt