how to keep string format

  • 24Views
  • Last Post 24 November 2022
Tina Tibbitts posted this 21 November 2022

We are importing data from our Azure SQL Server database.  We have a table with a list of courses and the Course Number is a text field.  However, one school uses the format of ####:### (i.e., 5200:55) instead of BIO 101 for their Course Numbers.  When I test the query in Skyvia the results show it as it is in the database, but the Google Sheet is changing the format for those fields to duration which changes the values to something different (i.e., 5205:5:00).  How can I force Google Sheets to not change the data type?


Yevheniia Bilotserkovska posted this 24 November 2022

Hello Tina.  

Thank you for contacting us.  

In this case, we would recommend you to change column type on the Google Sheets side. You can open your spreadsheet, select the column you need and choose on the toolbar Format - Text.  

Please let us know whether it helps.  

Best regards,

Yevheniia Bilotserkovska