Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using OO calc and i have one column with phone numbers that have leading 0s, which are vital for the number to be valid. I can format the cell as text but i do not want the numbers to be quoted when exported to csv. At the same time i have some other columns that need to stay automatically quoted . How can i do this?

share|improve this question
Why don't you want the phone numbers to be quoted? So you can store them as numbers? As you found out yourself, that doesn't work. What about extensions? International numbers also have significant '+' symbols. They're text, store them as text. – Dour High Arch Jun 20 '13 at 1:38

You must log in to answer this question.

Browse other questions tagged .