New Posts For Thread: Excel helphttps://community.betfair.com/general_betting/go/thread/view/94082/26169569/excel-helpI've generated a number by combining numbers in several cells using the ampersand. However if I try to use the result in a vlookup it's not recognising it as a number and vlookup doesn't work.Any advice?Cheers. The cut and paste worked. Will bear in mind the helper suggestion for next time.https://community.betfair.com/general_betting/go/thread/view/94082/26169569/excel-help?post_id=472463405#472463405Cheers. The cut and paste worked. Will bear in mind the helper suggestion for next time.Sun, 31 Oct 2010 21:40:56 -0500Try using a helper columnSay your ampersand cell is D1 in another column enter =VALUE(D1) and then you can use vlookup on your new cellhttps://community.betfair.com/general_betting/go/thread/view/94082/26169569/excel-help?post_id=472388065#472388065Try using a helper columnSay your ampersand cell is D1 in another column enter =VALUE(D1) and then you can use vlookup on your new cellSun, 31 Oct 2010 11:09:04 -0500Try this old chestnut.Type a number 1 in a box. right click the box and "copy" so it's on the clipboardThen use paste special and multiply all the text boxes by the 1. It may force them all to be numbers (It may not)https://community.betfair.com/general_betting/go/thread/view/94082/26169569/excel-help?post_id=472384149#472384149Try this old chestnut.Type a number 1 in a box. right click the box and "copy" so it's on the clipboardThen use paste special and multiply all the text boxes by the 1. It may force them all to be numbers (It may not)Sun, 31 Oct 2010 10:34:50 -0500I've generated a number by combining numbers in several cells using the ampersand. However if I try to use the result in a vlookup it's not recognising it as a number and vlookup doesn't work.Any advice?https://community.betfair.com/general_betting/go/thread/view/94082/26169569/excel-help?post_id=472383205#472383205I've generated a number by combining numbers in several cells using the ampersand. However if I try to use the result in a vlookup it's not recognising it as a number and vlookup doesn't work.Any advice?Sun, 31 Oct 2010 10:28:42 -0500