Reply to thread

Message

<blockquote data-quote="Yarthok" data-source="post: 4440416" data-attributes="member: 64890">Infocynic, Thanks for the suggestion. I checked and the cell format is already set to 'number'. I can't seem to force a text string cell value into a number when the cell value is produced by a formula that results in a text string.&nbsp; e.g SkillInsight is produced from (partial... ;&quot;+&quot;&amp;F73+B73+ ...) which, by using the text concatenation operator '&amp;', converts the numeric addition calculation into a text string with a '+' prefix. The final resulting cell value is a text string. The VALUE() function, that I used in other cell formulas is converting that text string into a number so it can then be used in a mathematical function (e.g. to compute passive insight.)If the origin cell starts out as a number, then no conversion is required. </blockquote>

[QUOTE="Yarthok, post: 4440416, member: 64890"] [LEFT][/LEFT] [LEFT]Infocynic, [/LEFT] [LEFT]Thanks for the suggestion. I checked and the cell format is already set to 'number'. I can't seem to force a text string cell value into a number when the cell value is produced by a formula that results in a text string. [/LEFT] [LEFT]e.g SkillInsight is produced from ([I]partial[/I]... [B];"+"&F73+B73+[/B] ...) which, by using the text concatenation operator '&', converts the numeric addition calculation into a text string with a '+' prefix. The final resulting cell value is a text string. The VALUE() function, that I used in other cell formulas is converting that text string into a number so it can then be used in a mathematical function (e.g. to compute passive insight.)[/LEFT] If the origin cell starts out as a number, then no conversion is required. [SIZE=5][FONT=Verdana][SIZE=5] [/SIZE][/FONT][/SIZE] [/QUOTE]

Verification