NPV Formatting

[rogerdodger]

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?

[seckert]

Make your formula '=1*NPV()' and then format to taste. This circumvents the autoformat.