View Single Post
 
Old 05-30-2017, 01:11 PM
JoyLearner JoyLearner is offline Windows 7 64bit Office 2016
Novice
 
Join Date: May 2017
Posts: 3
JoyLearner is on a distinguished road
Default Convert cell with formula to literal value

Cell B64 formula: =TEXT(TEXT(INT(SUM(B8:B59)/123*100),"0%")/100,"0%")
Cell B64 results: 68%

My project uses a webhook that needs to grab 68% as a literal text value.

What can I do to get the results of B64 into cell A64 that contains the literal value of 68%, with the value in A64 changing when the value of B64 changes? I'd even be happy with the literal value of 68 without the percent sign, if that is easier.

Thanks!
Reply With Quote