Forum Discussion
Solved
Spreadsheet data format
Hello folks, Everytime I download a excel spreadsheet, the dates converte to the brazilian format (dd/mm/yyyy). I tried a lot of ways to fix it but it doesnt work. I need it to be uploaded in t...
Do you mean that applying a different format to the cells does not change the way they look?
If so, Excel treats the values as text instead of as dates.
Try the following:
- Select a column with such values.
- On the Data tab of the ribbon, click Text to Columns.
- Select Delimited, then click Next > twice.
- Select Date, then select DMY from the drop-down list.
- Click Finish.
Applying a date format should now work, hopefully.
HansVogelaar thank you for the information.
How can I change this pattern to the US format? Even if I select a cell and change the format it still remains the same.
Do you mean that applying a different format to the cells does not change the way they look?
If so, Excel treats the values as text instead of as dates.
Try the following:
- Select a column with such values.
- On the Data tab of the ribbon, click Text to Columns.
- Select Delimited, then click Next > twice.
- Select Date, then select DMY from the drop-down list.
- Click Finish.
Applying a date format should now work, hopefully.
HansVogelaar Thank you Hans! It works now.
