answersLogoWhite

0

If you see a cell with a lot of has symbols in it, like #####, it usually means the cell is not wide enough to display its contents. This normally applies to numbers, not text. If you widen the column that the cell is in, it will display the contents correctly.

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

How do you remove hash tags in cells Microsoft Excel?

The hash tags appear because the cells are not wide enough to show their contents. You just need to widen the cells to show the values.


Excel text By default?

By default, text in Excel is left aligned.


How can I fix my Instagram the hash tags don't appear with my picture help please?

In order to fix your Instagram hash tags so that they will appear with your picture, you need to re-post the picture and write the hash tags that you want it to have. Hash tags will not appear unless you manually put them in each time.


What character forms when numeric data is to big for excel?

The hash character which looks like this: #


What is a feature of Excel that allows you to create curved or stylized text for a chart?

Excel does not create stylized text, but you can insert WordArt. You will find the WordArt option in Excel 2007 on the Insert tab in the Text section.


How will the Excel contents appear in Word?

If you copy data from Excel and paste it into Word, then it will appear as a table in Word.


How to open Excel file in dos editor?

A DOS editor is not capable of reading a standard Excel file. An Excel file must be opened with Excel or some application that can read Excel files. Text editors are not capable of doing that. They are designed for working on things like text files.If you have a standard Excel file and save it as a text file, then text editors can open them. All that will be in that is pure text, and not things like formulas and calculations and formatting etc. When you are saving as a text file, save it with a txt extension and most text editors will be able to open it. How you specifically do it will depend on the particular text editor you are using.


How do you use the the mini toolbar to apply formatting to text in a cell?

When text is selected in an Excel 2007 document, the "Mini Toolbar" will appear. The "format" option allears here in the same way as it does on the main toolbar. Simply select this option and choose how the text is to be formatted.


Can Excel recognize the following text 401AX21?

There is no reason why you cannot type that in. As there are letters in it, it will be treated by Excel as text.


What is the label in excel?

text in a cell


Is Excel a spreadsheet processor and a text editor?

It is a spreadsheet, but not a text editor.


Does Excel have the same text format and alignment shortcuts as in Word?

A lot of them are the same, but not all of them. For example, Ctrl - E does not centre text in Excel.

Trending Questions
What are the special alt characters? How do you get a sata hard drive to work on a PC that only supports ide hard drives what method would be best for drive and PC speed? Is it okay to feed a baby corn snake 2 mice? Why is the sound in avi files distorted as if the movie is playing too slowly This happens only in a specific computer the same file is ok on other computers? My son has a 50 lb 6 mo white lab. He currently feeds him 1 cup 3 times a day. The problem is his rib's show he's skinny and after I feed him he cries for more food. How much should we feed him? What does it mean to say a 200 lap race is official after 100 laps? What is the process of changing the contents of the text document? What does filling mean in Excel? What city is halfway between Peoria iil and Dunedin fl? What does programmable in programmable devices mean? What is the animated graphic that answers questions? How many kilobytes in a 3 minute song? Can Sony Vegas sessions be transfered into pro tools sessions? How do you change the time on a Nixon watch? What is Buses and what does it do? What is the bit rate of the following signals aA signal in which bit lasts for 0.001 seconds bA signal in which bit lasts for 2ms cA signal in which 10 bits lasts for 20s dA signal in which 1000 bits? What is the dominating DBMS? What does the first column of data specifically describe? What technology is used for authentication users? How many pages of a twelve page document will print if you push the print button in the standard toolbar?