#1   Report Post  
Alex
 
Posts: n/a
Default Date format of cells

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
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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?

Alex wrote:

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


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format date dd.mm.yyyy to dd/mm/yyyy Kiwi User Excel Discussion (Misc queries) 7 May 7th 23 11:44 AM
Australian date format in Excel 2000 Brian Jones Excel Discussion (Misc queries) 2 March 30th 05 06:13 AM
Excel 2000 date format cannot be set to Australian date format Brian Jones Excel Discussion (Misc queries) 1 March 30th 05 06:03 AM
Min/Max formulas using cells with date format WDS2000 Excel Worksheet Functions 1 February 7th 05 07:03 PM
problem with formatting cell to date format Del Excel Worksheet Functions 7 December 8th 04 06:14 PM


All times are GMT +1. The time now is 01:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"