Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Bob is offline
external usenet poster
 
Posts: 972
Default After importing MS Word text, all cells are filled with #####

After importing MS Word text, all cells are filled with #####, even short
text that should not have exceeded the character limit in Excell cells.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default After importing MS Word text, all cells are filled with #####

Change the formatting to General.

Excel has a problem with cells having between 255 and 1024 charaters when
formatted as Text.


Gord Dibben MS Excel MVP

On Tue, 10 Jun 2008 14:26:01 -0700, Bob wrote:

After importing MS Word text, all cells are filled with #####, even short
text that should not have exceeded the character limit in Excell cells.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filled cells dont appear as filled SMILLS Excel Discussion (Misc queries) 6 October 18th 07 05:28 PM
How do I sum color filled cells in Excel with no values or text? Oy! Excel Discussion (Misc queries) 2 March 9th 06 05:59 PM
Exporting and Importing Named cells to and from a text file clayton Excel Discussion (Misc queries) 0 January 18th 06 08:01 PM
importing list with commas from WORD, to individual .xls cells? brantty Excel Discussion (Misc queries) 1 August 5th 05 12:31 AM
Help importing text files into individual cells saybut Excel Discussion (Misc queries) 4 May 31st 05 03:24 PM


All times are GMT +1. The time now is 08:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"