I desperately need some help,

I have a VB app that populates a column with product numbers that are
numeric but are right filled with zeroes. ie. "006876".

If I set the cell value to "'006876" it works but I get the pesky green
triangle with a "number stored as text error". I don't want this, I
simply want it to be stored as a normal string.

I know I can click the button and select "ignore error", but I don't
want my users to have to do this every time.

Is there a way I can say " range.ignoreerror = true " or something like
that.

Any help would be much appreciated.

Thanks,
Peter