Convert cell with formula to literal value

		Microsoft Office Forums > Microsoft Excel > Excel
Convert cell with formula to literal value

FAQ

Thread Tools

Display Modes

05-30-2017, 01:11 PM

JoyLearner JoyLearner is offline

Windows 7 64bit Convert cell with formula to literal value

Office 2016

Novice

Join Date: May 2017

Posts: 3

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!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Entering a column value in a cell, to be used as part of a reference in a formula in another cell	paulkaye	Excel	4	02-26-2017 04:18 AM
convert text cell to numeric cell	mikec	Excel Programming	2	08-19-2015 02:51 PM
Convert non-cell input to cell values	TBD	Excel	3	06-09-2014 06:14 AM
Convert Formula Result to Static Text	MYGS	Excel	16	01-21-2013 08:18 AM
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:18 AM.