×
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.
On Wed, Jan 16, 2013 at 4:30 PM, Ken Sims <mdrg8066@xxxxxxxxxxx> wrote:
Why can't Excel just believe that I know what I'm talking about when
in a CSV file I put double quotes around a value that just happens to
be digits????
This is why it is often better to create Excel files directly rather than CSVs.
If you know the data is going to be opened in Excel, but for some
reason you can't create Excel files, then you can do some ugly
(formula-based) hacks in your CSV which will guarantee that Excel
treats your data as text. But with all the free and commercial Excel
libraries available on the i, there isn't much excuse not to just
create Excel files.
CSV is still a convenient and relatively efficient method of data
transport when you control both ends and neither end involves Excel.
John
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
