Thread: Prevent text converting to date in copy&pasting tables
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PatrickJ PatrickJ is offline
external usenet poster
  
Posts: 7
Default Prevent text converting to date in copy&pasting tables
Copying large data tables into MS Excel automatically converts MS
date-sensitive text into a date. How can I stop this? Pre-formatting cells in
columns totext does not work.
--
Patrick Johnstone, UK
Reply With QuoteReply With Quote