How to Disable date recognition

D

DL

Hi There,
I would like to know how to disable date recognition in MS
Excel. This causes problem when importing and/or
copy/paste data from other sources (MS Word/HTML page) to
Excel (e.g. original data is 01-6601 but after the
copy/paste or import, it becomes Jan-01).

Many Thanks
 
N

Nick Hodge

Realistically the only way is either to pre-format the cells as text or to
prefix the entry with a single apostrophe. (This will not show but will
treat the data as text). This last route may have problems later if you
need to do any calculations on the data (Other than counting entries of
course) or if you want to use VLOOKUP or similar

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

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

howto: disable date recognition? 0
Disable Date Recognition? 3
Disable Date Recognition 2
Excel changes 01-6601(text field) to Jan-01 when copy/paste 4
Excel How to calculate in excel number of open actions that expired (older then today) 0
date recognition problem 4
Converting date format 4
to lookup data for 'today()' 2

Top