howto: disable date recognition?

G

Giedrius

Hi,

I have a question "how to disable date recognition in Excel 2007"
for example:
1. copy->paste: if text contains something like "1.2" - it is converted to a
date
2. explorer "open tab delimited txt file with Excel": every cell values is
converted to date if possible (nonsense)
3. typing 1.2: converts to date

I know how to format cells to text before typing or "copy->paste". But this
does not work for nr.2
Is the any availabe solution to completely or partially disable date
recognition, since this is the most annoying function for me?


Thanks for any answer
Giedrius
 

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

Disable Date Recognition? 3
Disable Date Recognition 2
Excel-How Do I prevent data conversion to date format 3
How to Disable date recognition 1
Disable paste option in worksheet. 1
Mysterious re date Format 1
Disable Cut/Copy/Paste in Excel 2010 0
Excel Data pastes into 2 cells not 1 1

Top