icaine
Reputation: 444
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?
Upvotes: 0
Views: 348
Answers (1)
icaine
Reputation: 444
After some trial/error i have found that wrapping the function IMPORTDATA() with ARRAYFORMULA() seems to prevent this behaviour:
=ARRAYFORMULA(IMPORTDATA("..."))
Upvotes: 1
Related Questions
- Stop Excel from automatically converting certain text values to dates
- Google Spreadsheet importing CSV with arbitrary date formatting?
- Can I preserve custom data formats in a Google sheet when I import data into it from a CSV?
- How to avoid Scientific Notation when importing a csv into Excel?
- Keep Excel from converting dates when opening/saving CSV
- Changing Number type to Text type when import csv by vba
- How import text (csv) data into Libre Office Calc without auto-conversion to numbers
- Importing CSV into Excel: import wizard fails to recognize text qualifier but opening directly in Excel converts to scientific notation
- How can I stop Excel from formatting values such as 10-3 as a date?
- Preventing R from interpreting text as numeric