LinkBack URL
About LinkBacks
if i typed a formula, for example: =MATCH(hanif;A1:A999;0). Will returns a number, but i want that number does not have formula, so the formula in that cell is just a number of the result. How to make it?
returns a result and removed the formula
if i typed a formula, for example: =MATCH(hanif;A1:A999;0). Will returns a number, but i want that number does not have formula, so the formula in that cell is just a number of the result. How to make it?
Press F2 and when it is in editing more press F9 to get the result of formula (equivalent to paste special values).
Caution:- Formula will no longer available in that cell.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thank you. I'll try it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks