date format in UK

[kojr]

Is there have date format in
dd/mm/yyyy
since I can only find mm/dd/yy in excel
if no any way to change it
thanks....

 

[al_b_cnu]

Hi,

If you cant see the format in the 'Date' category, try a custom format.


i.e. Format|Cells|Number|Custom and type 'dd/mm/yyyy' in the box.

HTH

Alan

 

[Ahampson9658]

format the cell as custom you'll find it in there

if not you can add it

cheers