Prev: IF, THEN HELP
Next: I want to conditionally format an entire column after 1 year from
From: LCdebaca on 29 Apr 2010 12:59
I am creating a formula to copy data from one cell to another and I always
get the $ in my formula. I do not want to copy the same data that is in that
cell, so I have to go in and manually remove the $. How do I fix this issue.
From: Eduardo on 29 Apr 2010 13:08
Hi,
you can remove all the $ sign using find and replace, press CTRL + H, find
what enter $, then go to the field replace with but do not enter anything and
click ok

"LCdebaca" wrote:

> I am creating a formula to copy data from one cell to another and I always
> get the $ in my formula. I do not want to copy the same data that is in that
> cell, so I have to go in and manually remove the $. How do I fix this issue.
From: Joe User on 29 Apr 2010 13:29
"LCdebaca" wrote:
> I am creating a formula to copy data from one cell to
> another and I always get the $ in my formula. I do
> not want to copy the same data that is in that cell,
> so I have to go in and manually remove the $. How
> do I fix this issue.

You need to be more specific.

By "formula to copy data", I presume you mean that you have something like
=A1 in A2 in order to "copy" the value of A1 into A2. Right?

But first you say want to "copy data from one cell to another", then you say
you "do not want to copy the same data". What do you really mean? Do you
mean that want the same value, but not the same appearance?

And it is not clear what you mean by "$ in my formula". Do you mean that
you have =$A$1 (absolute reference) and you want =A1 (relative reference)?
Or do you mean that the value of the copy displays "$", and you do not want
it; for example, $123.45 should appear as 123.45?

The latter might require a simple change in cell format. But it would be
helpful to know the source of the "$" in the first place. Does it appear in
the original cell (A1 in my example)? If so, why: cell format; or text?

To change the format, click Format > Cells > Number.

If you mean that you have =$A$1 and you want =A, obviously you simply do not
type the "$" when you enter the formula. If you are entering the formula in
some way that automatically creates an absolute reference, you can move use
the cursor to select (highlight) the reference (e.g. $A$1), then press F4
several times to cycle through the difference kinds of cell references until
you find the one you want.

 | 
Pages: 1
Prev: IF, THEN HELP
Next: I want to conditionally format an entire column after 1 year from