This question relates to Calc Version: 188.8.131.52
Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75
Locale: en-US (en_US)
Windows 7 Professional English
Quicken can create a tab-separated file that is suitable for importing to a spreadsheet. When I look at that output, there are no extra characters added to any of the fields. However, after importing into LO using the “insert>sheet from file” function, the date cells are all preceded by what appears to be the ’ character (i.e. lowercase " on my QWERTY keyboard). The presence of the ’ makes the cell into text such that when I change the format of the cell to “date”, nothing happens because the ’ apparently stops the formatting as a date. If I manually remove the ’ everything behaves as I would expect.
Fair enough, but it’s a pain to remove all of those ’ by hand. So, I tried search and replace but I cannot figure out how to get the function to find the ’ character. I’ve tried copying the character from a cell into the search box and still LO cannot find it.
What is the correct incantation/procedure to stop the import process from inserting the ’ in the first place, or to get the computer to remove it after the fact?