Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How do I block date format assumptions? (Was: How do I change the name of a mod?

  Asked By: Kristopher    Date: Oct 21    Category: MS Office    Views: 390
  

I'm copying from a non-Excel source. Sometimes I'm
using "text to columns" to separate the fields after I paste.

The same problem occurs if I simply type "4-1" into a blank cell.
Unless I preformat that cell as "Text", my "4-1" will immediately
and irrevocably be 4/1/2008. (or 39539).

Share: 

 

No Answers Found. Be the First, To Post Answer.

 




Tagged: