Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 20th 05, 06:30 PM
Kevin
 
Posts: n/a
Default Need Workaround for Cell Display Limitation in Excel 2000

Greetings! I am using Excel 2000 and have run up against a limitation in the
number of characters a cell will display. According to Excel's help, a cell
can contain up to 32,767, but will only display up to 1,024. This, of course,
begs the question of why allow a cell to contain 32K when you're only going
to allow it to display 1K?

Does anyone have an effective workaround for this? I tried some trickery
with merging cells, but that didn't seem to help.

Also, I'm just curious, but does this same limitation exist in subsequent
versions of Office?

Thanks in advance!
--
Kevin

  #2   Report Post  
Old April 20th 05, 06:39 PM
Max
 
Posts: n/a
Default

Try breaking the lines with a few "ALT + ENTER"s

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Kevin" wrote in message
...
Greetings! I am using Excel 2000 and have run up against a limitation in

the
number of characters a cell will display. According to Excel's help, a

cell
can contain up to 32,767, but will only display up to 1,024. This, of

course,
begs the question of why allow a cell to contain 32K when you're only

going
to allow it to display 1K?

Does anyone have an effective workaround for this? I tried some trickery
with merging cells, but that didn't seem to help.

Also, I'm just curious, but does this same limitation exist in subsequent
versions of Office?

Thanks in advance!
--
Kevin



  #3   Report Post  
Old April 20th 05, 06:50 PM
Kevin
 
Posts: n/a
Default

I just tried your suggestion, but that did not seem to solve the problem. Did
it work for you? Maybe I'm doing something wrong.

Thanks

"Max" wrote:

Try breaking the lines with a few "ALT + ENTER"s

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Kevin" wrote in message
...
Greetings! I am using Excel 2000 and have run up against a limitation in

the
number of characters a cell will display. According to Excel's help, a

cell
can contain up to 32,767, but will only display up to 1,024. This, of

course,
begs the question of why allow a cell to contain 32K when you're only

going
to allow it to display 1K?

Does anyone have an effective workaround for this? I tried some trickery
with merging cells, but that didn't seem to help.

Also, I'm just curious, but does this same limitation exist in subsequent
versions of Office?

Thanks in advance!
--
Kevin




  #4   Report Post  
Old April 20th 05, 07:19 PM
Max
 
Posts: n/a
Default

Try this previous post from Harlan: http://tinyurl.com/9sgbw
Looks like you need to break for newline (Alt+Enter)
every 100-200 characters
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Kevin" wrote in message
...
I just tried your suggestion, but that did not seem to solve the problem.

Did
it work for you? Maybe I'm doing something wrong.

Thanks



  #5   Report Post  
Old April 20th 05, 09:11 PM
Kevin
 
Posts: n/a
Default

Max:

Thanks for the link. I'll give that a try.

"Max" wrote:

Try this previous post from Harlan: http://tinyurl.com/9sgbw
Looks like you need to break for newline (Alt+Enter)
every 100-200 characters
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Kevin" wrote in message
...
I just tried your suggestion, but that did not seem to solve the problem.

Did
it work for you? Maybe I'm doing something wrong.

Thanks






  #6   Report Post  
Old April 20th 05, 11:33 PM
Max
 
Posts: n/a
Default

You're welcome !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----




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
Find & Replace results to display specified chosen fields samuel Excel Discussion (Misc queries) 1 December 28th 04 08:43 AM
Conditional display of a .jpeg file? sbhogle Excel Discussion (Misc queries) 2 November 30th 04 05:57 AM
Data Filter - Not all rows in spreadsheet will display in Autofilt Excel Help Excel Worksheet Functions 1 November 17th 04 05:40 PM
how to display heading of column corresponding to the cell angelrain Excel Worksheet Functions 2 November 2nd 04 04:57 PM
Combine & Display “Fixed” & “Automatically Updated” Date Parts texcel Excel Worksheet Functions 1 November 1st 04 05:38 PM


All times are GMT +1. The time now is 12:45 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017