Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-08-2020, 04:41 PM
kjc kjc is offline Excel range pasted into Word shows ##### instead of numbers Windows 10 Excel range pasted into Word shows ##### instead of numbers Office 2019
Novice
Excel range pasted into Word shows ##### instead of numbers
 
Join Date: May 2020
Posts: 12
kjc is on a distinguished road
Default Excel range pasted into Word shows ##### instead of numbers


When pasting from Excel into Word, sometimes some of the numbers show up as ##### rather than numbers. It doesn't happen all of the time and only seems to happen on one PC. Has anybody see this before?
Reply With Quote
  #2  
Old 05-08-2020, 06:27 PM
macropod's Avatar
macropod macropod is online now Excel range pasted into Word shows ##### instead of numbers Windows 7 64bit Excel range pasted into Word shows ##### instead of numbers Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,358
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

That suggests the Excel column is too narrow for reliable display of the data.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 05-09-2020, 02:13 PM
kjc kjc is offline Excel range pasted into Word shows ##### instead of numbers Windows 10 Excel range pasted into Word shows ##### instead of numbers Office 2019
Novice
Excel range pasted into Word shows ##### instead of numbers
 
Join Date: May 2020
Posts: 12
kjc is on a distinguished road
Default

Thanks for the response, macropod. That was our first thought, but that's not it.
The Excel numbers show fine in Excel but it literally pastes "#######" into the Word doc.
Reply With Quote
  #4  
Old 05-09-2020, 02:25 PM
macropod's Avatar
macropod macropod is online now Excel range pasted into Word shows ##### instead of numbers Windows 7 64bit Excel range pasted into Word shows ##### instead of numbers Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,358
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Did you actually try widening the Excel columns?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 05-09-2020, 02:26 PM
kjc kjc is offline Excel range pasted into Word shows ##### instead of numbers Windows 10 Excel range pasted into Word shows ##### instead of numbers Office 2019
Novice
Excel range pasted into Word shows ##### instead of numbers
 
Join Date: May 2020
Posts: 12
kjc is on a distinguished road
Default

Yes, we did.
Reply With Quote
  #6  
Old 05-09-2020, 06:41 PM
macropod's Avatar
macropod macropod is online now Excel range pasted into Word shows ##### instead of numbers Windows 7 64bit Excel range pasted into Word shows ##### instead of numbers Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,358
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

I am unable to replicate that behaviour without making the Excel columns too narrow.

Have you tried repairing the Office installation on the affected PC and updating its display drivers?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
Old 05-10-2020, 11:37 AM
kjc kjc is offline Excel range pasted into Word shows ##### instead of numbers Windows 10 Excel range pasted into Word shows ##### instead of numbers Office 2019
Novice
Excel range pasted into Word shows ##### instead of numbers
 
Join Date: May 2020
Posts: 12
kjc is on a distinguished road
Default

Thanks Paul, We did an Office Repair (full online version) a couple of weeks ago.
In Device Manager, I've done update driver on the displays.
Reply With Quote
  #8  
Old 05-10-2020, 02:15 PM
macropod's Avatar
macropod macropod is online now Excel range pasted into Word shows ##### instead of numbers Windows 7 64bit Excel range pasted into Word shows ##### instead of numbers Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,358
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Quote:
Originally Posted by kjc View Post
Thanks Paul, We did an Office Repair (full online version) a couple of weeks ago.
In Device Manager, I've done update driver on the displays.
Neither of this is necessarily applicable to your current situation. If the problem has emerged since your Office Repair "a couple of weeks ago", the fault may also have occurred since then. The place to check for updated drivers is not Device Manager, but the maker's website.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Tags
#####, excel to word

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to adjust line spacing of a table pasted into Word from Excel rkeck05 Word VBA 2 01-03-2020 10:17 PM
Excel range pasted into Word shows ##### instead of numbers Returns in Word table text become multiple rows when pasted in Excel blorence Word Tables 8 01-23-2019 01:57 PM
how to shows cells range depending on dropdown menu value mfran2002 Excel 5 10-26-2017 08:08 AM
Web string/link in Excel, Mail merged into Word and then pasted into Messages on Mac issue Alex Knight Excel 0 12-08-2016 08:33 AM
Excel range pasted into Word shows ##### instead of numbers Sr. Citizen Question, Please: WORD Shows Blank, But Notepad Shows "Gibberish" ? Robert11 Word 3 08-12-2013 12:35 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft