[PLUG] LO Calc formatting question

Dick Steffens dick at dicksteffens.com
Tue Jun 5 22:50:11 UTC 2018


On 06/05/2018 03:46 PM, Rich Shepard wrote:
> On Tue, 5 Jun 2018, Dick Steffens wrote:
>
>> Did you try, in the Text Import options, Other Options, [x] Quoted field
>> as text along with [x] detect special numbers? I have to do this when I
>> import .csv data from the credit union.
>
> Dick,
>
>   No, I didn't. I selected a new spreadsheet and opened the .csv file. No
> importing of data.
>
>   I selected all text columns and formatted them as text, the selected 
> all
> numeric columns and selected the floating point numeric format. When I 
> saved
> it I checked the box to quote text fields and specified double quotation
> marks.
>
> Thanks,

You're welcome. I remember that I found that trick, but I don't remember 
how I found it. So, I'm glad it works for you, but I can't explain why. :-)

-- 
Regards,

Dick Steffens





More information about the PLUG mailing list