How do you copy an exact value to another cell? (not copying formulas)

**indolence** · 05-18-2009, 04:59 PM

What command do I enter so that a value in one cell is copied EXACTLY to another cell? For example, I have today's date in cell A4 and I want the exact date to be automatically copied to cell E5.

I can't seem to figure out the correct function to do this. I looked for help but there are just ways to transfer formulas over to other cells.

**shg** · 05-18-2009, 05:02 PM

Welcome to the forum.

In E5, =A4

**indolence** · 05-18-2009, 05:07 PM

thanks

wow, I was so caught up in thinking of some formula like COPY, EXACT, etc. that I didn't even think about that... simplicity is key.

**shg** · 05-18-2009, 05:08 PM

Yup.

Would you please mark the thread as Solved? (How To ... in menu bar.)

**indolence** · 05-18-2009, 05:15 PM

one quick question, thought I'd just add this in before I mark it as solved.

When I enter a formula, the value shows "0" at default. How do I make it so that a cell is blank until I enter values? For example, In cell A3, I want to add A1 and A2 but I want A3 to appear blank until I enter something into A1 or A2.

**shg** · 05-18-2009, 05:19 PM

=if(count(A1:A2)=0, "", A1+A2)

**abdul43** · 05-03-2013, 06:38 AM

but the problem is i want the exact number or value in the target cell not the formula because a macro is linked to the target cell and that needs an exact number and cannot catch the original value which it is showing by =A4.
for example:

if i write in cell C5 (=A4)
it shows the result as the value in a4 but in formula bar it is still a linked value and i want the exact number.
can u please help me.

Originally Posted by shg

Welcome to the forum.

In E5, =A4

**arlu1201** · 05-03-2013, 07:19 AM

abdul,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.