×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I can create a file in SQL that has formulas in it (i.e. '=A1*B1') and I can send them to my PC and open them in Excel 2002. However, the formulas are showing instead of the results. If I click inside the cell and hit Enter, I get the value instead of the formula. BUT, I want this automated and don't want a macro, so I want this to be opened to show the formula result instead of the formula without doing anything. I tried using CAST to a few other types, but that didn't work. It works if I send it as a HTML, but would prefer the xls extension, if possible. Thanks for any thoughts on this.
-Jeff
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
