Help!

show text instead of hash marks

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  Customizing Subject Field  
Author Message
Nicko
External


Since: May 12, 2007
Posts: 4



PostPosted: Wed Feb 25, 2009 4:10 am    Post subject: show text instead of hash marks
Archived from groups: microsoft>public>excel>misc (more info?)

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
Back to top
Pecoflyer
External


Since: Feb 25, 2009
Posts: 1



PostPosted: Wed Feb 25, 2009 8:10 am    Post subject: Re: show text instead of hash marks [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
Back to top
Nicko
External


Since: May 12, 2007
Posts: 4



PostPosted: Wed Feb 25, 2009 8:10 am    Post subject: Re: show text instead of hash marks [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
>
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum