View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
wilywayne wilywayne is offline
external usenet poster
 
Posts: 3
Default change a currency number display

THANKS FOR THE HELP...THE FORMULA THAT I USED IS =PMT(L42/23,L43,M41)
THE L42/12 IS THE MONTHLY INTEREST RATE, L43 IS THE TERM IN MONTHS AND M41
IS THE DOLLAR AMOUNT....

"tim m" wrote:

=ABS(A1)

If you post your formula we can show you how to incorporate the ABS function
into it.

"wilywayne" wrote:

I have created a formula to calculate a real estate payment, which returns a
negative number as the result. I need to change the negative number to a
postive number to use in other formulas. How do you do it?