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

Top