answersLogoWhite

0


Best Answer

The hash symbol is displayed, like this:

############

User Avatar

Wiki User

8y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: When the total number of characters of numeric data is greater than the column width of a cell what is displayed?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

When a total number of characters of numeric data is greater than the column width of cell what is displayed?

The hash symbol is displayed, like this: ############


How do you change column A default to a numeric number?

In Excel all columns default numeric characters to numbers.


When the total number of characters of numeric data is greater than the column width of a cell?

You will get a series f hash symbols "####". To see the value look at the formula line or change the column width using the format command.


How many characters can be entered in a single cell Microsoft Excel 2003?

32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.


Numeric data is wider than the column it is recorded in?

This is not a question, but my best guess to answer is: If the numeric data is too wide for the column, then increase the width of the column.


What column is not displayed in the Audit Log?

Failure


What column is not displayed in the Audit Log in epo?

Failure


What happens if a label is too long for a cell in a spreadsheet?

If labels are longer than the column width allowed, the spreadsheet does not "lose" the extra characters; instead they are not displayed if the cell to their right has an entry.


What type of column will automatically right align the data when displayed?

date


What symbol displays the erro message on deleted row or column?

Deleting a row or column can cause some formulas not to be able to reference a value resulting in the #REF! error being displayed in the affected cells.Deleting a row or column can cause some formulas not to be able to reference a value resulting in the #REF! error being displayed in the affected cells.Deleting a row or column can cause some formulas not to be able to reference a value resulting in the #REF! error being displayed in the affected cells.Deleting a row or column can cause some formulas not to be able to reference a value resulting in the #REF! error being displayed in the affected cells.Deleting a row or column can cause some formulas not to be able to reference a value resulting in the #REF! error being displayed in the affected cells.Deleting a row or column can cause some formulas not to be able to reference a value resulting in the #REF! error being displayed in the affected cells.Deleting a row or column can cause some formulas not to be able to reference a value resulting in the #REF! error being displayed in the affected cells.Deleting a row or column can cause some formulas not to be able to reference a value resulting in the #REF! error being displayed in the affected cells.Deleting a row or column can cause some formulas not to be able to reference a value resulting in the #REF! error being displayed in the affected cells.Deleting a row or column can cause some formulas not to be able to reference a value resulting in the #REF! error being displayed in the affected cells.Deleting a row or column can cause some formulas not to be able to reference a value resulting in the #REF! error being displayed in the affected cells.


Which organizational structure is easily displayed in student's notes written in two columns with an action on the left column and the result of the action in the right column?

No


In a table the specific field names are displayed at?

At the top of each column of each table.