excel dates

[bot754]

how can i make all the dates in a column the same. some format are d/m/yyyy and some are dd/mm/yyy(which i want) how do i make them all dd/mm/yyyy.

 

[snjpverma]

1. Select the columns you want to format.
2. Right-click and select “Format Cells”.
3. In the “Number” tab, select “Date” from the “Category” list.
4. Choose the desired date format from the “Type” list and click “OK”.

This will change the format of the selected cells to your desired date format.

 

[bot754]

1. Select the columns you want to format.
2. Right-click and select “Format Cells”.
3. In the “Number” tab, select “Date” from the “Category” list.
4. Choose the desired date format from the “Type” list and click “OK”.

This will change the format of the selected cells to your desired date format.

i have done that however some dates are inconsistent

Copy of Product and Transaction List

Copy of Product and Transaction List Transaction,State,Date,Product,Wholesale Price,Units Sold,Product Code,Sales,Month,Year 202020100539,Northen Territory,01/01/2018,Viper Earmuffs,61.425,6,SB038557-SM,368.55,01 - Jan,2018 202020100510,Queensland,01/02/2018,Mineral Absorbent,240.45,5,TN139874-M...

docs.google.com

if you can check my google spreadsheet and check that will be great.

 

[snjpverma]

Sorry, I won't be using a system until a week's time. Hopefully someone else would chip in.