'How to prevent google spreadsheed's IMPORTDATA() from interpreting text values as dates/numbers?
Into a google spreadsheet i want to import a csv data (with IMPORTDATA() function) that contains some arbitrary (textual) codes. The function tries to (incorrectly) interpret some of those codes as numbers/dates and setting text as cell format for destination cells doesn't help.
So how to prevent IMPORTDATA() from automatic text to number/date conversion?
Solution 1:[1]
After some trial/error i have found that wrapping the function IMPORTDATA() with ARRAYFORMULA() seems to prevent this behaviour:
=ARRAYFORMULA(IMPORTDATA("..."))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | icaine |