View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
wolfman wolfman is offline
external usenet poster
 
Posts: 3
Default Invert Negative number?

If by 'invert' you mean to negate negative numbers, use the ABS() function
then all conversions result in positive values. If you mean to swap positive
for negative (or vice versa) use the suggested x = -x or X = X*(-1). Hope
this helps