Discussions

Expand all | Collapse all

"save as spreadsheet" erasing my leading zeros

  • 1.  "save as spreadsheet" erasing my leading zeros

    Posted 7 days ago
    I have a Text field that contains numeric account numbers that generally start with Zero  (ie:  04201345).  They show fine in Quickbase, but when i "Save as Spreadsheet", the account number field always erases the leading 0, (IE: 4201345)

    Is there a way to make sure those Zero's stay all the time?

    ------------------------------
    Jamie Brown
    ------------------------------


  • 2.  RE: "save as spreadsheet" erasing my leading zeros

    Posted 7 days ago
    Hi Jamie,

    This is a excel behaviour and not a quickbase download issue. Do not double click the csv file directly to open in excel. This will trim the trailing zero and treat it as number instead of text. 
    Try this one. close the excel and open again. Open the file using menu-file-open file, locate your csv and the open.

    ------------------------------
    Babi Panjikar
    ------------------------------



  • 3.  RE: "save as spreadsheet" erasing my leading zeros

    Posted 7 days ago
    Jamie,

    This is very frustrating and is a Microsoft problem not Quick Base.   You need to import the .csv into a workbook.

    Then you will need to transform the data column to Text to get the prevailing zeros.

    It is a real pain.

    Don


    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------



  • 4.  RE: "save as spreadsheet" erasing my leading zeros

    Posted 7 days ago
    Make a formula text field and use that on the report you want to Save as Spreadsheet

    formula text - combine single quote with original account number
    "'" & [Textfield]​


    If you add a single quote to beginning of the text string that contains a number, Excel will show the leading zeros




    ------------------------------
    Everett Patterson
    ------------------------------