When I copy and paste dollar values into my spreadsheet, a leading apostrophe is attached to the dollar value. '$115.91
It doesn't appear in the cell, only in area that displays the cells that are to be summed.
xgenhanx wrote:When I copy and paste dollar values into my spreadsheet, a leading apostrophe is attached to the dollar value. '$115.91
acknak wrote:When you import the data, make sure the "Quoted fields as text" option is OFF (unchecked), and select comma as the field separator and " as the text delimiter. That works for me with your sample.
JJJoseph wrote: If OO doesn't make any progress with MS CSV handling, and keeps inserting that hated apostrophe where it's not wanted, it looks like I'll be back here again with the same question
JJJoseph wrote:If OO doesn't make any progress with MS CSV handling,
JJJoseph wrote:MS CSV handling
Users browsing this forum: No registered users and 24 guests