Cheers to a New Year!
As stated above, in one of my formulas using PMT I get the result in red like so: ($123.45) and when I use the PMT in another section I get: -$123.45. Any Ideas what it could be?
Best Regards
John Paul
Cheers to a New Year!
As stated above, in one of my formulas using PMT I get the result in red like so: ($123.45) and when I use the PMT in another section I get: -$123.45. Any Ideas what it could be?
Best Regards
John Paul
Hello johnpaulluna. Welcome to the forum.
This sounds like a format ... Accounting or Custom ... is applied to those cells .
Dave
Tried changing to either, now I have black text instead of red.Screen Shot 2019-01-03 at 6.48.36 PM.png
OK.
Which format do you prefer? Try applying that format directly or use Format Painter after you've applied it to one of the ranges.
Good point. I went to 'Number Format' then 'More Number Formats' and found 'Currency' with the option to select red with negative numbers. Thank you for the suggestion!
You bet. Glad to help. Thank you for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks