I need to copy & paste a large table (54 pages of data) from Word to Excel.
Works great except when some of the cells contain ranges (1-10, etc), Excel insists on interpreting them as dates and promptly CORRUPTS the data (you CANNOT obtain the original value back by applying Text formatting to the cells... the original value is GONE!).
Is there any way to completely disable the date auto-format feature? Or perhaps trick Excel into thinking the '-' is not a valid date separator?
The file I want to convert is actually publicly available here:
http://www.cms.hhs.gov/ElectronicBillingEDITrans/18_5010D0.asp#TopOfPage
Scroll down to "Excel formats - Remittance, Claim Stauts Inquiry and Response, Eligibility Inquiry and Response [ZIP, 310KB]" Then inside it find a WORD file which I urgently need to get in EXCEL format without corrupting the ranges.