Date format of cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am downloading a result to excel and there are date formats in that result.
When I copied thedate formatted cells and paste it to a new
workbook/spreadshhet..the dates are changing into numbers. I tried doing this
by using another computer and the results are fine, I can copy and paste the
cells as is to another workbook/spreadsheet. Is this set-up related? If so,
can you please help me configure my excel so that I don't have to re-format
the cells to date format.

Thanks,
Alex
 
Any chance you're viewing formulas in the worksheet you're pasting?

Tools|options|View|uncheck Formulas

What does the number look like?

If you pasted 3/30/2005 (march 30, 2005) into a cell, do you get 38441?

If no, what number do you get?

If you format the cell as a nice looking date, does it change the display?
 

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

Remove date format? 3
Transferring files from a MAC 1
from date format convert to text format is wrong 2
How do I stop Excel from copying date format from cell above? 2
format text to date results in ############## 4
data turned in date format when copied 2
retain custom date format "text" when pasting or reformatting data 2
Cell Format 1

Back
Top