View Single Post
 
Old 12-22-2019, 10:50 PM
WJSwanepoel WJSwanepoel is offline Windows 10 Office 2007
Advanced Beginner
 
Join Date: Dec 2019
Location: Krugersdorp, South Africa
Posts: 82
WJSwanepoel is on a distinguished road
Default Pasting data copied from MS Word

I am copying a table from MS Word 2007 to Excel. Some of the cells contain text such as 4:10. When I paste it in Excel it is automatically formatted as a time (10 past 4).

How do I stop Excel from automatically formatting when I paste? I have tried pre-formatting the cells as "text" but it does not help.
Reply With Quote