Removing hh:mm

[Omar]

Dear all,
I have more then one cell with the following format, dd/mm/yyyy
hh:mm , how can I remove hh:mm only.
Regards,
Omar.

 

[Pete_UK]

Select those cells then right-click and choose Format cells. On the
number tab choose custom and enter dd/mm/yy in the box (or delete
hh:mm from the box if they all have that format). Click OK.

You can also do this to just one cell and then use the Format Painter
to apply the format to other cells - double-click the Format Painter
icon and then click on whichever cells where you want to change the
format. Press <Esc> when you've finished.

Hope this helps.

Pete