Converting functions into numbers

  • Thread starter Thread starter vesuvius
  • Start date Start date
V

vesuvius

For example, using the function =2*3, I will get a 6 in the cell.

Now I would like to copy the 6 into another cell.

Using the usual copy, I will copy the function.

Is there a way that I can copy the 6 as a number and not as a function
 
Assumed you had the formula in cell A1 and you want your value copied to
C1, insert the '=A1' into cell C1. However, if A1 changes, C1 certainly
will change as well.
 
hiya, yeah, but that will copy the function as well :(

my intention is

(i) to copy the cell's number value, without copying the function
(ii) to store the cell's number value which is derived from the
function, while removing the function

can I do that?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 5
Copying Formula - Please help 2
Converting functions into numbers 1
Addition function of multiple cells 10
I need to remove the zeroes in a chart 1
excel macro 1
Function that can differentiate between text & numbers??? 6
Combining Letters and Numbers 1

Back
Top