Quotes i.e"" in the following equation
=ClosePosition(A11,1,"0",D11)
Quotes i.e"" in the following equation
=ClosePosition(A11,1,"0",D11)
Last edited by omega0010; 07-21-2013 at 11:48 AM.
will return the value in cell B11, surrounded by single quotes, eg: '50'. IF you must use double quotes, I think you'll need to look up the CHAR number for them, and use that.Please Login or Register to view this content.
Hope this helps.
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
Thanks for the great help but as I dont know anything about this I wish to tell you that if that value is 50 as you have said then it should show as "50" and NOT '50'
Further I dont even know what a char number is and any way this number is going to be a random number.
Last edited by omega0010; 07-21-2013 at 12:10 PM.
Did you try looking up the CHAR number for ", as I suggested? If, as you claim, you "don't know anything about this", you could always try having a look, you know - there's plenty of information on the internet, for example here, or you could of course check Excel's online help.
The CHAR # for " is 34, so to wrap the VALUE of cell B11 in " and ", the formula would be:
Please Login or Register to view this content.
Thanx a ton !
It is extremely accurate and I will try to use it and see
Thanks again !
Glad to be able to help, omega, and cheers for the rep.
You can also use triple quotes
=ClosePosition(A11,1,"""0""",D11)
Thanx for the tip but it does not work !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks