Thread
:
Indirect
View Single Post
#
2
Posted to microsoft.public.excel.misc
Ron Rosenfeld[_2_]
external usenet poster
Posts: 1,045
Indirect
On Tue, 1 Oct 2013 13:43:42 -0700 (PDT),
wrote:
it now evaluates correctly. I see no obvious difference between the two workbooks. Why do I need to add "TEXT" to the formula in workbook "B" to get it to evaluate correctly?...TIA, Ron
In workbook B you have selected to enable the Lotus options. Where this is located depends on your version.
In Excel 2007+, they are under the Office Button / Excel Options / Advanced
In earlier versions, explore the Tools/Options drop down menu.
Reply With Quote
Ron Rosenfeld[_2_]
View Public Profile
Find all posts by Ron Rosenfeld[_2_]