Error while pasting data from Board

[CA_Punit]

Please refer this post

Complex Index/Match or Search/Find (VBA would be an option as well)

Good afternoon. I am trying to do a lookup that is a bit more complex than I imagined. I need to basically find a word in a column to determine which value to return. The kicker is that I need to ensure that mutilple finds are a match to pull in the right value. For Example: Headings i have are...

www.mrexcel.com

Where LindenWolf posted the data which had number stored as text.

But when i copied down the data and pasted the data in excel the text number got converted to number. The number became unrecognizable

Is there any way the data is pasted as per the format of the OP???

 

[smozgur]

It is actually expected behavior since 202,203,204,205,206,207,208,209,210,302,303,304,305,306 is a numeric value with thousand separators.

However, this is first time that I see this kind of entry sample showing this problem. I think, being not sure, this issue could be solved.

Thanks for reporting, @CA_Punit. I'll let you know if it could be solved as soon as I analyze it.

 

[smozgur]

Update:
Although I will be changing the way how XL2BB to treat text formatted cells as text however they look, this will still happen since the copied text is a legit number that Excel will try to convert no matter happens during the BB2XL (copy from thread to Excel). It is just like copying 123,234,345,456,567,789,890 from here and trying to paste in Excel.

This doesn't have a solution as we can't force how Excel works with clipboard object but thanks again for reporting, @CA_Punit. It helped me to catch and fix another related issue.