Text field with numeric values is truncated or changed when exported to excel.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a text field call [Account Number] that usually (but not always) contains only numeric values. If this contains greater than 15 characters, then characters 15 and onward are saved to excel as zeros. If the number starts with 0 (or 00, 000, etc) none of the leading zeros will be part of the excel spreadsheet. 

Adding any kind of non-numeric character circumvents these issues, but then I have to remove that character once it's in excel. Is there a better way?

Photo of Taylor

Taylor

  • 52 Points

Posted 3 years ago

  • 0
  • 1
Photo of dwhawe

dwhawe, Champion

  • 908 Points 500 badge 2x thumb
This is actually an Excel issue and not a QuickBase issue.  When you export, save directly without opening in Excel.  Opening in Excel causes Excel to interpret the format and will choose numeric or scientific on its own.  Since actual numbers never have leading zeros, then it truncates.

Once saved, change the extension to .txt

Then open as a txt file in Excel which will allow you to control the column types and make sure that column is Text