Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.