Hello
In a column I entered dates like 09/27/1958. I then formatted it using mmmm
to get month name. In next col. I wanted the month names and hence I copied
the full column of dates, clicked on next column, from paste special I chose
values, but again it result as "09/27/1958". what wrong am I doing?
Thanks

Value in a date cell is a number representing the date, it remains the same
number when pasted.
Use
=TEXT(A1,"mmmm")
in the result cell to get month name!

Regards,
Stefi

€ždindigul€� ezt Ã*rta:

Hello
In a column I entered dates like 09/27/1958. I then formatted it using mmmm
to get month name. In next col. I wanted the month names and hence I copied
the full column of dates, clicked on next column, from paste special I chose
values, but again it result as "09/27/1958". what wrong am I doing?
Thanks

On pastespecial use "Values and number formats" which is at the end of the
options.

"Stefi" wrote:

Value in a date cell is a number representing the date, it remains the same
number when pasted.
Use
=TEXT(A1,"mmmm")
in the result cell to get month name!

Regards,
Stefi

€ždindigul€� ezt Ã*rta:

Hello
In a column I entered dates like 09/27/1958. I then formatted it using mmmm
to get month name. In next col. I wanted the month names and hence I copied
the full column of dates, clicked on next column, from paste special I chose
values, but again it result as "09/27/1958". what wrong am I doing?
Thanks