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. <This is
exactly what I was looking for. @discussions.microsoft.com wrote:
"Pete" wrote:
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- Hide quoted text -

- Show quoted text -