How do you turn off autoformatting? Every time I make a change within the formula of a cell that has a PV, NPV, IRR, etc. function in it, it automatically reformats to currency when I press enter. This is annoying, I have already formatted in accounting. How do I turn this off?
Make your formula '=1*NPV()' and then format to taste. This circumvents the autoformat.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks