I did as you said, preformat the cells as text. But it could not stop it from converting automatically with the copy&paste. Cells data will be pasted from a html table.
see http://www.box.net/shared/9pix25pbop (including an impress file and an html file with talbe) On Mon, Nov 23, 2009 at 1:02 AM, JOE Conner <[email protected]> wrote: > Patapon wrote: > >> how to prevent the calc from converting 3.1.2 to "03年1月2日"(localized) >> >> Thanks in advance. >> >> >> > 1. Format the cell as text. > 2. preceed entering with an apostrophe. > > Joe Conner, Poulsbo, WA USA > >
