ExcelBanter - View Single Post

DavidM

Thanks Kevin

"Kevin B" wrote in message
...
Create a custom format that looks like this

Select the cells to format, click FORMAT in the menu and select CELLS and
click on the NUMBER tab. Select CUSTOM from the category list and enter
the
following formatting mask in the TYPE: field:

ddd dd-mmmm-yy

for Fri 13-October-06

for a complete day of the week use dddd
for an abbreviated month use mm
--
Kevin Backmann

"DavidM" wrote:

Hi all

I have in column I dates like 5/16/2006 which show in cells as 16-May-06
how could I get them to show as, Tue-16-may-06

Thanks in advance

Dave