SOLVED

Spreadsheet data format

Copper Contributor

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 the US format (mm/dd/yyyy). 

 

Can someone help me with this? 

4 Replies

@aliceoliveirathoughtw 

Excel has two 'universal' date formats, Short Date and Long Date. They are marked with an asterisk * in the Format Cells dialog:

HansVogelaar_0-1719429815213.png

If you apply one of those two formats, Excel will automatically display the dates in the user's Short Date or Long Date format as specified in the Windows/MacOS settings. So I'd see 2024-06-26, you'd see 26/06/2024, and someone in the USA would see 06/26/2024. The underlying stored date will be the same in all cases.

If you want to force a cell to display using USA format, use mm\/dd\/yyyy as custom format.

@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. 

 

aliceoliveirathoughtw_0-1719491291930.png

 

best response confirmed by aliceoliveirathoughtw (Copper Contributor)
Solution

@aliceoliveirathoughtw 

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. :happyface:

1 best response

Accepted Solutions
best response confirmed by aliceoliveirathoughtw (Copper Contributor)
Solution

@aliceoliveirathoughtw 

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.

View solution in original post