Hi,
This is what I did:
-Selected markets in guardian
-Connected it to the sample unchanged BetAngel_Multiple.xls
-Created a new sheet in the sample xls, where I wanted to create a summary
Problem: whenever I try to use ='Bet Angel'!B9 to grab the home team's name from the other sheet, it is treated as text instead of a function, thus obviusly it won't update.
On the other hand if I try to grab the odds from the other sheet, it does work.
I'm totally lost now, tried everything I can, reinstalled another version of excel, another language of excel, it doesn't help.
Am I missing something trivial here? (could be)
I can post the xls file or a screenshot if required.
Thanks for your help in advance.
Excel problem - functions treated as text
I met that problem before. a friend give me a web, he said you can find your answer and get what you want.
http://www.keepautomation.com/products/net_barcode/
i tried, and i find an interesting stuff, you can generate different kinds of barcode for Excel or Microsoft Office.
http://www.keepautomation.com/products/net_barcode/
i tried, and i find an interesting stuff, you can generate different kinds of barcode for Excel or Microsoft Office.
-
- Posts: 13
- Joined: Tue May 21, 2013 11:32 am
Thanks a lot!! I have also faced the same problem. Happy that got the solution.
- OnGoldWires
- Posts: 49
- Joined: Mon Jul 20, 2009 7:07 pm
I have encounted this myself and I have an alternative solution to Format as general, Right click, f2 mentioned in a separate thread.
I select the problem data, go to the DATA menu and convert to by the Text to Columns icon and selecting General data format in step 3 of the Wizard. This method means that you can only sort the problem on a column by column basis (but the problem is nornally confined to one column) and care has to be taken to ensure the data is not split into more columns, but otherwise it works like a charm.
I select the problem data, go to the DATA menu and convert to by the Text to Columns icon and selecting General data format in step 3 of the Wizard. This method means that you can only sort the problem on a column by column basis (but the problem is nornally confined to one column) and care has to be taken to ensure the data is not split into more columns, but otherwise it works like a charm.