How to Disable date recognition

  • Thread starter Thread starter DL
  • Start date Start date
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
 
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)
 
Back
Top