date format being changed?

  • Thread starter Thread starter yawnmoth
  • Start date Start date
Y

yawnmoth

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)
 
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
 
Format>Cells>Number>Custom

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

Pre-format before pasting your copied data..


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tally the figures acquired from the same date 3
Dates changed on Copy Cell 6
date format convert 2
Can't get simple chart to look right 3
Conditional Formatting based on dynamic Date 1
How do I change dd/mm/yy to dd-month-yy? 6
Problem formatting dates from CSV file 2
Hidden Formating Or Delimiters: Showing Of ? 2

Back
Top