MS Office X Excel date problem

M

Mrs.K

When I copy and paste a spreadsheet containing dates
written in date format (1/1/04) it sometimes changes the
format to text, as in Jan.1/04. In text format I can not
sort by date or change it back to date format. Is this a
bug in the program? Can I prevent this from occurring?
 
J

JE McGimpsey

Mrs.K said:
When I copy and paste a spreadsheet containing dates
written in date format (1/1/04) it sometimes changes the
format to text, as in Jan.1/04. In text format I can not
sort by date or change it back to date format. Is this a
bug in the program? Can I prevent this from occurring?
Click to expand...

Are your cells that are converting preformatted as Text? Are you sure
the source you're copying from is in XL date format and not Text?
 
R

Rob

JE said:
Are your cells that are converting preformatted as Text? Are you sure
the source you're copying from is in XL date format and not Text?
Click to expand...

Or maybe you should just accept this fact of (XL) life and reformat the
destination cells after pasting.

I am not convinced that the target formatting is text. It probably is
<mmm.d/yy>, change it to <m/d/yy>

Rob
 

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

Paste to excel from word - auto format problem 1
Excel does not accept text format! 0
VBA - exporting serial letters to single documents 0
Date Formats 4
Problem with MS Word paragraph and character styles: format getting messed up 2
Can't sort by date 2
Modify the gantt chart view in project center (WPA) (MS Project 2010) 0
New computer, how do i move outlook 365 ENTIRELY? 0

Top