View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CaptainQuattro
 
Posts: n/a
Default How to prevent Excel converting imported fractions into dates


One way to change the way Excel will treat this data is to select Tools,
Options, Transition.. and select Transition formula entry.

If you are simply copying your table to the clipboard and pasting into
excel, they will display as decimals, but the underlying fractions will
be preserved.

Another method would be to perform an interim step of copying your
table to a notepad plain text document. Save the notepad table as
something like table.txt and then use the

Data, get external data... wizard in excel. (In Excel 2003 this
function is named slightly differently, but is still under the Data
Menu)

Original Data type will be delimited
Click Next. Choose Tab as the delimiter
Click Next and for each column choose Text as the Column Data format.

Hope this helps.


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=526517