date format being changed?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yawnmoth - 21 Mar 2008 18:36 GMT

Why is it that in a particular Excel spreadsheet, whenever I paste
"3/20/2008 9:34:00 AM" into it, I get "Tuesday, March 20, 2008" (or
whatever)? How can I change this behavior? (I didn't create the
Excel spreadsheet)

Reply to this Message

Tyro - 21 Mar 2008 19:14 GMT

Change the formatting of the cell. Select the cell. Then press Ctrl+1 and
select the Number tab. Then select date. Then select the format you want.
Instead of date, you can also select custom and create your own date format.
It's also possible that whatever you're pasting has a format associated with
it and it's that format you're seeing. If so, when you paste, do a paste
special and select values. If you see a number after doing so, format the
cell as a date.

Tyro

> Why is it that in a particular Excel spreadsheet, whenever I paste
> "3/20/2008 9:34:00 AM" into it, I get "Tuesday, March 20, 2008" (or
> whatever)? How can I change this behavior? (I didn't create the
> Excel spreadsheet)

Reply to this Message

Gord Dibben - 21 Mar 2008 22:11 GMT

Format>Cells>Number>Custom

m/dd/yyyy h:mm:ss AM/PM

Pre-format before pasting your copied data..

Gord Dibben MS Excel MVP

>Why is it that in a particular Excel spreadsheet, whenever I paste
>"3/20/2008 9:34:00 AM" into it, I get "Tuesday, March 20, 2008" (or
>whatever)? How can I change this behavior? (I didn't create the
>Excel spreadsheet)

Reply to this Message