View Single Post
 
Old 09-15-2025, 10:58 AM
chrisjj chrisjj is offline Windows 7 64bit Office 97-2003
Competent Performer
 
Join Date: Aug 2025
Posts: 120
chrisjj is on a distinguished road
Default Excel 2003 - Getting Paste to keep values as text

In Word I have a table with cells containing just e.g. 2021-11. Copy and Paste to Excel converts it to a number.

This is despite that I used the advertised trick of preformatting the cells as Text - and verified by entering the same text manually, as a test.

Is there any way to get this text retained? I can't Paste as Text since I need other format inc. hyperlinks. I do not want to kludge the large table by hand.

Thanks.
Reply With Quote