show text instead of hash marks

Nicko · External Since: May 12, 2007 Posts: 4

When I enter text into excel, I push enter and it show up as one line of hash
marks.

How can I change this back to the original text?

Nicko

Pecoflyer · External Since: Feb 25, 2009 Posts: 1

Nicko;245399 Wrote:
> When I enter text into excel, I push enter and it show up as one line of
> hash
> marks.
>
> How can I change this back to the original text?
>
> Nicko

Hi,

make the column width larger

HTH

--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=68450

Nicko · External Since: May 12, 2007 Posts: 4

Thanks Pecoflyer, but that didn't work. I figured out that if right click
and go into "format cells" and change the category to "General" under the
"Number" tab it converts it all back into text.

Cheers

"Pecoflyer" wrote:

>
> Nicko;245399 Wrote:
> > When I enter text into excel, I push enter and it show up as one line of
> > hash
> > marks.
> >
> > How can I change this back to the original text?
> >
> > Nicko
>
> Hi,
>
> make the column width larger
>
> HTH
>
>
> --
> Pecoflyer
>
> Cheers -
> *'Membership is free' (http://www.thecodecage.com)* & allows file
> upload ->faster and better answers
>
> *Adding your XL version* to your post helps finding solution faster
> ------------------------------------------------------------------------
> Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
> View this thread: http://www.thecodecage.com/forumz/showthread.php?t=68450
>
>