software

How do I convert a negative number to a positive number? (without editing
every cell)

Use a formula in an adjacent cell and copy this down. If your data is
in A1, in B1 enter:

=ABS(A1)

and copy down for as many values as you have in column A. You can then
fix the values in B and copy them over the ones in A.

Hope this helps.

Pete
Hey Tedd,
One possibility for that is you can do CTRL H, replace, in find what,
use quot;-quot; and then replace with a blank in 'replace with'. This is
possible but it replaces all the negative numbers. Hence, you can use
this if you need to replace all in the worksheet.
Cheers.--
praveen_khm
------------------------------------------------------------------------
praveen_khm's Profile: www.excelforum.com/member.php...oamp;userid=30364
View this thread: www.excelforum.com/showthread...hreadid=502141Do you just want to convert negative-gt;positive (leaving positive numbers
positive)? If so, use the following formula:
=ABS(A1)

Drag this down to the end of your data. Then, copy this range and quot;Paste
Specialquot;-gt;Values over your original range.

If not, (you want to convert positive numbers to negative as well). Place
-1 in an empty cell and copy it. Then select your range of numbers and
quot;Paste Specialquot;-gt;Multiply.

Does that help?
--
Regards,
Davequot;Teddquot; wrote:

gt; How do I convert a negative number to a positive number? (without editing
gt; every cell)

I have a column of #s whose values are linked to a different worksheet. Some
#s are positive, others have a negative sign. I tried to search for the
negative symbol using the search/replace method you describe, but my search
both by quot;formulasquot; and by quot;valuesquot; does not find anything--yet I can see
several cells have negative numbers in them. Any thoughts?

quot;praveen_khmquot; wrote:

gt;
gt; Hey Tedd,
gt; One possibility for that is you can do CTRL H, replace, in find what,
gt; use quot;-quot; and then replace with a blank in 'replace with'. This is
gt; possible but it replaces all the negative numbers. Hence, you can use
gt; this if you need to replace all in the worksheet.
gt; Cheers.
gt;
gt;
gt; --
gt; praveen_khm
gt; ------------------------------------------------------------------------
gt; praveen_khm's Profile: www.excelforum.com/member.php...oamp;userid=30364
gt; View this thread: www.excelforum.com/showthread...hreadid=502141
gt;
gt;

Additional Item: The column that includes negative signs is formatted as a
Custom column with 13 zeros...I need to have leading zeroes and 13 places
total. In this format, the Find features does not seem to find the negative
signs.

Thanks again.

quot;praveen_khmquot; wrote:

gt;
gt; Hey Tedd,
gt; One possibility for that is you can do CTRL H, replace, in find what,
gt; use quot;-quot; and then replace with a blank in 'replace with'. This is
gt; possible but it replaces all the negative numbers. Hence, you can use
gt; this if you need to replace all in the worksheet.
gt; Cheers.
gt;
gt;
gt; --
gt; praveen_khm
gt; ------------------------------------------------------------------------
gt; praveen_khm's Profile: www.excelforum.com/member.php...oamp;userid=30364
gt; View this thread: www.excelforum.com/showthread...hreadid=502141
gt;
gt;



quot;Petequot; wrote:

gt; Use a formula in an adjacent cell and copy this down. If your data is
gt; in A1, in B1 enter:
gt;
gt; =ABS(A1)
gt;
gt; and copy down for as many values as you have in column A. You can then
gt; fix the values in B and copy them over the ones in A.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
gt;

Well, that shows the value of the archives - one of my early
postings !!

Glad it was useful to you.

Pete

On Sep 2, 3:28*pm, This is exactly what I was looking for. lt;This is
exactly what I was looking for. @discussions.microsoft.comgt; wrote:
gt; quot;Petequot; wrote:
gt; gt; Use a formula in an adjacent cell and copy this down. If your data is
gt; gt; in A1, in B1 enter:
gt;
gt; gt; =ABS(A1)
gt;
gt; gt; and copy down for as many values as you have in column A. You can then
gt; gt; fix the values in B and copy them over the ones in A.
gt;
gt; gt; Hope this helps.
gt;
gt; gt; Pete- Hide quoted text -
gt;
gt; - Show quoted text -