On Mar 8, 6:35*pm, Teethless mama
wrote:
=TEXT(A1,"ddd")



" wrote:
Hi

I was hoping someone could shed some light on this.I want column B to
identify the day in column A and express it as text.

I.E. when column A is 01/10/07,coumn B displays *' Mon'

column A * * * * * * column B
*01/10/2007
*02/10/2007
*03/10/2007

Thanks
David- Hide quoted text -

- Show quoted text -

Thanks for responding

Whenever i use =TEXT(A1,"ddd") ,column B displays
'01/10/2007'

Any suggestions.

David