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

Hi David,

In B1:

=A1
Format Custom as "ddd"

Copy down as far as needed

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message ...
| 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
|

=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

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

It sounds like your "date" is actually text with one or more leading spaces
in front of it. If I am correct, either convert the "date" to a real date
or, at minimum, remove the leading spaces, and Teethless mama's formula
should work. If you don't want to modify what you now have, then (again, if
I am correct) this formula should work for you...

=TEXT(TRIM(A1),"ddd")

Rick


wrote in message
...
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

When you press Ctrl+Accent grave (`), the key above the tab key, does cell
A1 display 39092, the date serial number for 1/10/2007? Or do you see
1/10/2007?
Press Ctrl+Accent grave (`) to return to normal display.

If you see 1/10/2007, your "date" is text with perhaps a space in it. That
is to say, it's not a date.

Tyro

wrote in message
...
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