Remove minus

[Guest]

I have a query that I am subtracting Feild1 from Field 2 I would like for
the difference to be a Whole some of my amount are negative number like -2
I would like to remove the minus sign can I do this?

Thanks

 

[Tom [Pepper] Willett]

Is this an Excel question? If so, you should ask an Excel newsgroup, not
FrontPage.

 

[Stefan B Rusynko]

See http://www.devguru.com/technologies/vbscript/quickref/abs.html

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| I have a query that I am subtracting Feild1 from Field 2 I would like for
| the difference to be a Whole some of my amount are negative number like -2
| I would like to remove the minus sign can I do this?
|
| Thanks