Text in cell is not visible! 8(
in [Programming]
|
Prev: Collating stock market data
Next: use command button to total datas in cells through VBA codes in ex
From: Robert Crandal on 1 Mar 2010 04:14 My cell is formatted to accept string type data. However, if the text length is bigger than the cell length then all I see are a bunch of "##################" characters in the cell. Can't Excel just show the text that fits in the cell and possibly clip off the text that extends beyond the cell??? How can I do this? thank u!
From: Dave Peterson on 1 Mar 2010 08:47
Try changing the format to General. Excel has trouble strings between 256 and 1024 characters in cells formatted as Text. Robert Crandal wrote: > > My cell is formatted to accept string type data. However, if > the text length is bigger than the cell length then all I see are > a bunch of "##################" characters in the cell. > > Can't Excel just show the text that fits in the cell and > possibly clip off the text that extends beyond the cell??? How > can I do this? > > thank u! -- Dave Peterson |