show text instead of hash marks
 

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

show text instead of hash marks
 

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/sh...ad.php?t=68450

show text instead of hash marks
 

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/sh...ad.php?t=68450