What do these characters (###) mean inside an excel spreedsheet cell?
What do these characters (###) mean inside an excel spreedsheet cell?
Hi
probably your column is not wide enough. Just make it wide enough :-)
--
Regards
Frank Kabel
Frankfurt, Germany
"k89af1" <[email protected]> schrieb im Newsbeitrag
news:[email protected]...
> What do these characters (###) mean inside an excel spreedsheet cell?
Pasted directly from Help on #####
**********************************
Correct a ##### error
Occurs when a column is not wide enough, or a negative date or time is used.
Review the possible causes and solutions.
Possible causes and solutions
Column is not wide enough to display the content
Increase the width of the column Select the column, point to Column on the
Format menu, click Width, and then enter a number.
Shrink the contents to fit the column Select the column, then on the Format
menu, click Cells, click the Alignment tab, and then select the Shrink to fit
check box.
Apply a different number format In some cases, you can change the cell's
number format to make the number fit within the existing cell width. For
example, decrease the number of decimal places after the decimal point.
Dates and times are negative numbers
If you are using the 1900 date system, dates and times in Microsoft Excel must
be positive values.
When you subtract dates and times, make sure you build the formula correctly.
If the formula is correct, although the result is a negative value, you can
display the value by formatting the cell with a format that is not a date or
time format. Click Cells on the Format menu, click the Number tab, and then
select a format that is not a date or time format.
Gord Dibben Excel MVP
On Mon, 3 Jan 2005 09:33:03 -0800, k89af1 <[email protected]>
wrote:
>What do these characters (###) mean inside an excel spreedsheet cell?
And one more.
If you've got a lot of characters in that cell (>255 but less than 1024), then
try changing the format of the cell from Text to General.
k89af1 wrote:
>
> What do these characters (###) mean inside an excel spreedsheet cell?
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks