Hi Violet,

For a value in A1:
=ABS(A1)

Cheers

--
macropod
[MVP - Microsoft Word]


"violet" wrote in message
...
is there any code that will allow me to retreive just the values of the
number and ignore whether the value is -ve or +ve.eg -3 return 3, 3 return
3