| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hash marks on graph with axis starting at nonzero number | Charts and Charting in Excel | |||
| GETTING RID OF LEADING HASH MARKS | Excel Discussion (Misc queries) | |||
| Graph with large data range (hash marks on axis) | Excel Discussion (Misc queries) | |||
| Show hash marks instead of text | Excel Worksheet Functions | |||
| Hash marks in a chart | Charts and Charting in Excel | |||
Hybrid Mode
