Forum Discussion
Excel file date instead of number
Hello, In this file coming from Uber eats, I should see numbers but instead i see dates or invalid value. how can I set up my excel to read correctly this type of file ? I imported on goog...
pedrodu69 Did you by any chance open a CSV file by directly clicking on it, or opening it in Excel? If so, try to import the file via the Data Ribbon. Get Data, From Text (Legacy) and follow the instructions. In step 3 of 3, make sure to mark all columns creating problems as Text. That will preserve them as texts. Otherwise a "number" like 5.46 may be interpreted as May 1946, just like in your screenshot.