Skip to main content
Question

Quickbase Text field downloads in numeric format to CSV?

  • July 27, 2023
  • 0 replies
  • 108 views
Forum|alt.badge.img+20

Does anyone have a work around for the following?

I have a table with Parcel Numbers. They can be quite long, something like 06545500006452300.

I have this in a text field. When downloaded to a CSV, it will show as 0654550E+12. Essentially, trying to turn it into a number which excel can't handle. Anyone run into this, and have a good work around?



------------------------------
Mike Tamoush
------------------------------

    MarkShnierYou
    Forum|alt.badge.img+24

    The only solution I know if is to have a formula to prepoernd a prefix like  

    *06545500006452300.

    That will cause the export to be seen as a text field type by Excel

    Then you will need to strip that prefix * out in Excel with a formula.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement