Mark Johnson wrote: > Where do I quote these? > "A","B","C","12345","000123"
The info I posted about single quotes in my last post wasn't helpful in this context. Let me try this way: A,"B","12,34",Hi "World" Excel doesn't need quotes unless you're doing something special, which explains why the A and B values are exactly the same. The "12,34" is special because it embeds a comma. Quotes are also needed when spaces are embedded, although sometimes leading or trailing spaces may also get removed. The \Hi "World"\ example is interpreted as alpha in the first place, so any quotes embedded in that value are considered part o the text string. 000123,="000123" The number with leading zeros is recognized it as numeric, so 000123 becomes 123 in the sheet. The ="000123" value tells Excel that this is a formula (preceded by equal sign). The formula returns a string which is not reinterpreted as above. "12/10/05" This date, even in quotes, is interpreted because there is not a forumula telling Excel to do otherwise, and will get converted to display "12/10/2005". The value itself will be converted to an internal numeric much like the internal Pick date. "=""12/10/05""" , ="12/10/05" These two values show equivalent formulas for expressing the date as a string, not a date to be converted as above. This just goes to show that sometime you need to "escape" a quote by preceding it with another quote. There are no formal standards which govern how CSV files work. There are generally accepted conventions, but of course these aren't all followed by Excel. Using the guidelines above you can experiment with certain kinds of data to see how it behaves. And none of this is related to U2. There are thousands of websites with this sort of information available. T ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
