Hi,
I have a cell with the value 00023455/2 in it, then i trim the content from both sides with a macro to the following value 23455
My problem is that one of my vlookups still don't see this as a unique number 23455. Thus the vlookup fails. i can even see that the cell content aligns itself to the left as if not recognising it as a value, but the momemt i click on the cell and on the content in the formula bar and enter then the value aligns to the right as a number.
How can i rectify this with coding?
any suggestions will be good
Thanks
eon5
I have a cell with the value 00023455/2 in it, then i trim the content from both sides with a macro to the following value 23455
My problem is that one of my vlookups still don't see this as a unique number 23455. Thus the vlookup fails. i can even see that the cell content aligns itself to the left as if not recognising it as a value, but the momemt i click on the cell and on the content in the formula bar and enter then the value aligns to the right as a number.
How can i rectify this with coding?
any suggestions will be good
Thanks
eon5