Forum Discussion
pedrodu69
Dec 21, 2021Copper Contributor
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...
HansVogelaar
Dec 21, 2021MVP
Apparently you use comma as decimal separator and point (dot, period) as date separator.
The file uses point as decimal separator. This causes the confusion.
You can set Excel to use point as decimal separator:
- Select File > Options.
- Select Advanced.
- Clear the check box 'Use system separators', then specify point as decimal separator and comma as thousands separator.
- Click OK.
See if that works better.
You can tick 'Use system separators' again afterwards.