View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Living the Dream Living the Dream is offline
external usenet poster
 
Posts: 151
Default Delete Text in Multiple Cells

Hi

Depending on which version of Excel you are using:

< 2010:

Tools | Format Cells | Number Tab

2010:

Format | Format Cells | Number Tab

Choose Date, select whichever Display format you like including a custom
format of your own choosing.

HTH
Mick.