We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Cell Value in Formula Cells

Is there a way to get the actual numeric value in a formula cell. at the moment if I use, the .CellValue, it returns the Formula String

3 Replies

Administrator June 28, 2004 06:09 AM UTC

Try .FormattedText instead of .CellValue.

KT Kirito Tsusaki replied to Administrator February 26, 2018 01:22 AM UTC

Try .FormattedText instead of .CellValue.

agree

Sindhu Nagarajan February 26, 2018 10:47 AM UTC

Hi Suraj, 
  
Thanks for your update. 
Please let us know if you have any other queries. 
  
Regards, 
Sindhu. 

Loader.
Live Chat Icon For mobile
Up arrow icon