<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Change column format to "Date" adds ' to the beginning of field" href="https://bugs.documentfoundation.org/show_bug.cgi?id=108245#c10">Comment # 10</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Change column format to "Date" adds ' to the beginning of field" href="https://bugs.documentfoundation.org/show_bug.cgi?id=108245">bug 108245</a> from <a class="email" href="mailto:guilleron29@aol.com" title="Jacques Guilleron <guilleron29@aol.com>"> Jacques Guilleron</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=133785" name="attach_133785" title="a way to reproduce.">attachment 133785</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=133785&action=edit" title="a way to reproduce.">[details]</a> a way to reproduce. This is the usual behaviour. Most of the time, those apostrophes (simple quote marks) are added when we import table from web or a database. They are texts and, with or without apostrophe, they are aligned to left. This behaviour can be reproduce. I joined a document to show how it works. Column A was first text formated and filled next with numbers. Column B is a copie of column A, but an apostrophe was automaticly added at the copie time. Column D is get from column C by a formula, and give also a quoted column E by copie. Column B as column E can be transform to values by selecting them and Data > Text to columns… Another way to do that is to multiply by 1 or use a formula like =VALUE() Ok for the beer the next time we meet. Jacques</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>