show text instead of hash marks

N

Nicko

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
 
P

Pecoflyer

Nicko;245399 said:
When I enter text into excel, I push enter and it show up as one line o
hash
marks.

How can I change this back to the original text?

Nicko
Click to expand...

Hi,

make the column width larger

HT

--
Pecoflye

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

*Adding your XL version* to your post helps finding solution faste
 
N

Nicko

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
 
Top