dates format

[bot754]

can anyone help me with making the date format all the same as they are inconsistent. i would like it in the form dd/mm/yyyy

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,02/01/2018,Mineral Absorbent,240.45,5,TN139874-M...

docs.google.com

 

[Gimics]

Google Sheets!!



You could use a formula like

=TEXT(link to your cell here,"dd/mm/yyyy")

Or you could select column C and then pick a format from the "Format" button at the top of the page.

 

[bot754]

thank you, however when i tried pick the format it gave me inconsistent dates forexample some dates started with mm/dd/yyyy and not the one i picked which was dd/mm/yyyy

 

[Gimics]

No worries - you can see in column L of your spreadsheet the formula that I suggested.

This has to refer to an actual date, so don't get rid of the dates in column C.

But this should work for you?

 

[MARK858]

forexample some dates started with mm/dd/yyyy and not the one i picked which was dd/mm/yyyy

I assume that all the dates that are in dd/mm/yyyy format are on or before the 12th of the month?